Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hierarchy average as per case statement

Hi All,   I Have below data    Category Sub Category Value A       A2 1   A1 12 B       B3 6   B1 17 I need to give switch case as following    Categor...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Assume after subcategory level you want to sum /add the measure Average 

 

then

sumx(Values(Table[Sub category]),[Average])