Forum Discussion

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

How to create a new subtotal column from Measures ?

Hi there,   As in the first picture you can see that I have 3 columns. What I want to achieve here is the exact solution as picture second. Now I will explain.  As you can see there is a column na...
Need Help
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    Birinder I think  you want:

    Sub-Total Each Category Measure = 
  VAR __Quarter = MAX('Table'[Quarter])
RETURN
  SUMX(FILTER(ALL('Table'),[Quarter]=__Quarter),[Sales])


Margin Measure =
  [Sub-Total Each Category Measure] - MAX('Table'[Sales])
Birinder's avatar
Birinder
Icon for Helper III rankHelper III
4 years ago

Greg_Deckler 

Hi there, 

Thanks for the reply.

 

I want to ask you, Will this work if All the three columns ; "Quarter", "Model" and "Sales" are from 3 seperate tables, and are connected via relationship.

If Yes, then Inplace of "table" in code given by you, What am I supposed to enter.

 

Thanks and Regards