AVERAGE, AVERAGEA, AVERAGEX - DAX Guide

Подписаться 104 тыс.

Просмотров 25 тыс.

50% 1

AVERAGE: Returns the average (arithmetic mean) of all the numbers in a column.
dax.guide/average/

AVERAGEA: Returns the average (arithmetic mean) of the values in a column.
dax.guide/averagea/

AVERAGEX: Calculates the average (arithmetic mean) of a set of expressions evaluated over a table.
dax.guide/averagex/
This video is part of DAX Guide, the online guide to all the DAX functions, with links to related content and compatibility matrix with all the versions of Power BI, Azure Analysis Services (AAS), SQL Server Analysis Services (SSAS), SQL Server Data Tools (SSDT), and Power Pivot for Excel.

How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: www.sqlbi.com/books/the-defin...
Code, run, and share DAX with DAX.do: dax.do/?aff=yt

#dax #powerbi #ssas #tabular #analysisservices #powerpivot

Наука

Опубликовано:

9 мар 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 20

@encounter_consulting_agency Месяц назад

Hey, this is a great explanation! Thank you

@hermesjrd 3 года назад

Great, Great Videos Alberto, Thanks a lot

@irfanabbassi9202 2 года назад

Beautiful explaination

@kebincui 2 года назад

Thanks Alberto 👍

@powerbinareal 3 года назад

Sempre top

@user-wx3dn3il2f 3 года назад

Awsome!!!

@sanjay422a 3 года назад

I am using averagex function the total it shows in the table total is different when I used the same measure on the card. Why does it behave differently?

@AgulloBernat 3 года назад

basic doubt: if I don't use a measure for the second argument, do I need to use calculate to force context transition?

@SQLBI 3 года назад

It depends - you don't have to use CALCULATE if you use a column of the table you iterate. You likely need CALCULATE if you use an aggregation function.

@AgulloBernat 3 года назад

@@SQLBI thank you! Didn't find any example with calculate in dax.guide and got confused. Also, Why don't we need calculate for columns of the same table?

@SQLBI 3 года назад

Because you access with the row context, you need CALCULATE to apply a context transition (when you need it).

@AgulloBernat 3 года назад

@@SQLBI ok! I think I understood it now. (I've had this feeling before though!)

@Max-wo7zp 2 года назад

When I copy & paste these formulas in the calculated table formula bar, It gives errors. How can i use these formulas in the Power BI without DAXStudio ?

@SQLBI 2 года назад

You can test the code also on dax.do Just use dax.guide/averagex/ and execute the code using the "TRY IT" button. In Power BI you can paste the code of the measure definition in corresponding measures.

@maheshdama5392 3 года назад

please make a videos on all count functions

@SQLBI 3 года назад

You can already find the video on dax.guide We will publish videos on our RU-vid channel in the coming weeks, but you can access them directly now on our website.