Forum Discussion

Credo's avatar
Credo
Helper I
7 years ago
Solved

Calculate subtotal using dax

I would like to calculate a subtotal using dax (not using the subtotal feature of matrix visual)   Sample data:    Client Shop Sales A 1 100 A 2 200 B 3 400 B 4 500  ...
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    Credo Please try this as a "New Measure"

     

    Test107 = CALCULATE(SUM(Test107Measure[Sales]),FILTER(ALL(Test107Measure),Test107Measure[Client]=SELECTEDVALUE(Test107Measure[Client])))

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Add as measure

 

TotVal = CALCULATE(SUM(Table1[Sales]),ALLEXCEPT(Table1,Table1[Client]))