Forum Discussion
DAX AVERAGE MEASURE
Hi all,
I need some help to create an Average Dax Measure. I have this example, where every single raw has a sum, which is fine, because that's why I want to measure for each raw, but for the total I need the Average of all Sums. I've tried already AverageX, DistinctCount, but it appears that i am not close enough to find a solution.
To calculate the sums, I have already applied a quick measure where I've used the measure below. This quick measure it's good for me because all the sums are correct and I need them, but I can't figure out how can i do the avearge only for totals.
Thanks in advance.
Gheb_Gabriela , You measure like
AverageX(values(Date[Qtr Year]), calculate(Count(Table[Column]) ) )
2 Replies
- amitchandak
Super User
Gheb_Gabriela , You measure like
AverageX(values(Date[Qtr Year]), calculate(Count(Table[Column]) ) )
- Gheb_GabrielaFrequent Visitor
Great amitchandak thanks a lot! It's working.