Average of percentages

[Nishil]

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 · Accepted solution]

@Nishil ,

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]

@amitchandak Thanks it works fine.