Recently I'm confuse oh using AVERAGE or AVERAGEX function.
For example I have this Sales data (at first) :
I create a simple measure for the Total amount :
[Total amount] = SUM(Sales[Amount])
Then there is requirement which I need to join to some table and it product some duplicate row because of the join.
I need my Total Amount measure handle this duplicate rows, so I thought average between these duplicate value will do the trick, but apperntly not.
At first I created this addtional measure :
Do I need to use COUNTROWS and use DIVIDE instead ?
Go to Solution.
If you add all column on the table visual, please create a measure
Measure = CALCULATE(AVERAGE('Table'[Amount]),ALLEXCEPT('Table','Table'[SalesID],'Table'[OrderDate],'Table'[SalesTeritory]))
If you only add SalesID, SalesTeritory, OrderDate, Amount on the table, just create the measure
Measure 2 = AVERAGE('Table'[Amount])
View solution in original post
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!