Forum Discussion

Credo's avatar
Credo
Icon for Helper I rankHelper 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])))

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago

Credo Please try this as a "New Measure"

 

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

Credo's avatar
Credo
Icon for Helper I rankHelper I
7 years ago

Thanks a lot