topic Re: Average of percentages in DAX Commands and Tips

Average of percentages

Nishil — Tue, 01 Nov 2022 13:09:42 GMT

Hi ,

Can someone help me with Average of percentages?

EC and EO er distinctcount measures from 2 different fact tables which are connected to DimA and DimME.

CTO = EC/EO. But the total is wrong.

How do I get the correct total value which should be 18,47?

Made a copy of CTO as CTO1 so need to replace blank() with Dax formula for averages .

amitchandak — Tue, 01 Nov 2022 13:45:58 GMT

Using the correct level

averagex(Values(Table[Journey level 2]), [CTO1])

Correct the column name, for more than one level use summarize

averagex(Summarize(Table, Table[Journey Bame], Table[Journey level 2]), [CTO1])

If use calculation CTO1 in place of CTO1, then make sure you use calculate

Nishil — Tue, 01 Nov 2022 14:15:39 GMT

amitchandak Thanks it works fine.