Forum Discussion

mrbajana's avatar
mrbajana
Icon for Helper III rankHelper III
4 years ago
Solved

Average in Row Total Hierachy

I Have a simple division calculation, but for each sub category I need the average, and then the average for each category. How could I do this calculation in the Row Subtotals? File Attach https://drive.google.com/drive/folders/1oP3HokCAXO-RblYXLxA4nROqrBdIolxO?usp=sharing 

1 Reply

  • mrbajana , Based on what I got

    a new measure 

    AverageX(Values(Table[SKU]) ,[%diff])