Wrong average in DAX

[Anonymous]

Hi everyone,

Can anyone help me to get the right average of the measure "Score actuel"  in the total of page 3? I get 72 instead of 64.

Here is the pbix file : https://www.dropbox.com/s/vdb1mzcnfurnpbe/Sample%20eco%20score.pbix?dl=0

Thank you

Best regards

[v-easonf-msft]

Hi, @Anonymous 

Could you please tell me whether your problem has been solved?

If yes, you could accept the helpful answer as solution to close this thread.

Other community members will easily find the solution when they get the same issue.

Best Regards,
Community Support Team _ Eason

[MFelix · Accepted solution]

Hi @Anonymous ,

Using the IF statement on calculations for the matrix/table can bring incorrect totals just a dd the following measure:

Score Average = AVERAGEX(VALUES('Fact table'[URL]), Mesures[Eco Score]) + 0

[Anonymous]

Hello,

I realized that this formula doesn't take into account my drill-through filter. For example on page 1 when I right click on "FNAC" and drill-through "Details" the measure is calculated for all the URLs and not only for the URL of FNAC.

Is there any way I can change the measure to keep the filter from my drill-through?

Thank you,

Best regards

[Anonymous]

Thank you MFelix, it worked! 🙂