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 Ashish,
Ignore my last post I did what I thought you meant and it WORKS!!!!!!!!!
Brilliant...thank you very much...you have saved my PC from being thrown out of my window 😁

 

Paul

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

You are welcome.