Forum Discussion

Gheb_Gabriela's avatar
Gheb_Gabriela
Frequent Visitor
4 years ago
Solved

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.