DAX AVERAGE MEASURE

[Gheb_Gabriela]

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.

[amitchandak · Accepted solution]

@Gheb_Gabriela , You measure like

AverageX(values(Date[Qtr Year]), calculate(Count(Table[Column]) ) )

[Gheb_Gabriela]

Great @amitchandak thanks a lot! It's working.