Forum Discussion

Uzi2019's avatar
Uzi2019
Icon for Community Champion rankCommunity Champion
3 years ago
Solved

Divide Row value with Sub Total

Hello Expert, I need your help in getting the row subtotal value. I have given the example:     I am not able to get the sub total value through meaure. beacuse i need to divide row value...
Need Help
  • Tahreem24's avatar
    Tahreem24
    3 years ago

    Uzi2019 Try this DAX Measure:
    Measure = 

    VAR _Curr = SUM(Table[Spends])
    VAR _All = CALCULATE(_Curr,REMOVEFILTERS(Table[Product]))
    RETURN DIVIDE(_Curr,_All,0)
     
Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
3 years ago

Uzi2019 Try this DAX Measure:
Measure = 

VAR _Curr = SUM(Table[Spends])
VAR _All = CALCULATE(_Curr,REMOVEFILTERS(Table[Product]))
RETURN DIVIDE(_Curr,_All,0)
 
Uzi2019's avatar
Uzi2019
Icon for Community Champion rankCommunity Champion
3 years ago

Thanks Tahreem24 
Your solution actually works for me.