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.

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

Hi Miguel,

Many thanks for your reponse...I'm trying to implement it now but can't see where the Table[Project] comes from, in the  final line, or what to replace it with.

 

Paul

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

Hi Otto_Luvpuppy,

 

The table[project] is the column you present on your data that has the values Scheme 1, Scheme 2 and so on.

 

Since I did not know the name of the table and column place that generic name, you should replace by the column on your model regarding that Shecme values. 

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

    Hi Miguel,
    Thanks again for taking thee time with this. I tried the following using your code...

    VAR _Chance =
    CALCULATE (
    SUM ( Pipeline_MFMA[xDelChance_Number] )
    )
    VAR _Authorised =
    CALCULATE (
    SUM ( Pipeline_MFMA[xCPY1] ) - [CPY1_DEL_Unauthorised],
    Pipeline_MFMA,
    Pipeline_MFMA[xDevDel_CPY1] = "Delivery"
    )
    RETURN
    SUMX(VAlUES(Pipeline_MFMA),_Authorised * _Chance)
    Unfortunately I get the same result as I did with my original code.
     
    Paul 
  • Otto_Luvpuppy's avatar
    Otto_Luvpuppy
    Icon for Helper II rankHelper II
    4 years ago

    Hi Miguel,

    The problem is solved using a combination of your code and that of Ashish.....thank you both very much.

     

    Paul