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.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

Try this measure

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

Hope this helps.

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

Hi Ashish_Mathur - I had the same issue and this solution gives me the right result. However the Project field in my case is a field parameter. For example my measure is -
Measure Final =
var _total =
IF(HASONEFILTER(WD_Dim[L3]),[Measure Interim],
SUMX(VALUES(WD_Dim[L3]),[Measure Interim]))
return _total
This gives right result, but based on field paramater it can be L3, L2 field etc from the WD_Dim table , so how do i tweak the above measure to get that result?

  • 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]))

         

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

    Hi,

    I am not sure how much i can help but i can try.  Share the download link of the PBI file.  Show the visual clearly in which you have dragged the measure and would like to incorporate the change.