Forum Discussion

Otto_Luvpuppy's avatar
Otto_Luvpuppy
Icon for Helper II rankHelper II
4 years ago
Solved

Totals Calculations using a % - a real problem

HI, I have a calculation that's not working at the TOTAL level...it's fine at row level. I can see the problem and why it's happening but can't figure out a solution...hopefully a DAX Wizard will ha...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    Try this measure

    Measure = SUMX(VALUES(Pipelime_MFMA[Project]),[Year 1 Adjusted by Probability])

    Hope this helps.

MFelix's avatar
MFelix
Icon for Super User rankSuper User
2 years ago

Hi Otto_Luvpuppy ,

 

Currently you cannot use Field parameters to change your table dynamicaly, only option would be to do SUMX for each of the values in the field parameters.

askpbiuser's avatar
askpbiuser
Icon for Helper I rankHelper I
2 years ago

Thank you for your reply. That's clear. However I do have a related question and would be great if you can help. I have measure generated using formula (1-B) * A. The values appear right in Measure and I show them as % of column total using power bi functionality to show calc as % of column total in visualization pane.
However I want to achive same thing using measure. so I want a measure in DAX to show me same resultset as % of column total and could you please help. Result is measure value / grand total column of column, so 345,5/463,7 = 74,5%

 

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    2 years ago

    Hi askpbiuser

     

    Try the following code:

    % Total = DIVIDE([Measure], CALCULATE([Measure], ALLSELECTED(Table[Cust]))