Forum Discussion
Otto_Luvpuppy
Helper II
Helper IITotals 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...
Hi,
Try this measure
Measure = SUMX(VALUES(Pipelime_MFMA[Project]),[Year 1 Adjusted by Probability])
Hope this helps.
Otto_LuvpuppyHelper II
Helper IIHi Ashish,
So are you saying that my original measure is fine but use it in your measure for the table column I want to show?
Paul
Ashish_Mathur
Super User
Super UserYes.
- Otto_Luvpuppy
Ashish,
This solution works brilliantly if I create a seperate measure as you suggested but to reduce the number of measuer I thought the same logic would work if I simply created another variable in the first measure and then used your code after the RETURN....as shown below...CPY1_DEL_Authorised_% =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")VAR _Result = _Authorised * _ChanceRETURNSUMX(VALUES(Pipeline_MFMA),_Result)...but this gives the old incorrect result and I can't understand why.
What is different about using a seperate measure as a opposed to what I've done in the code with the variable? Just interested in why that happens....content to use seperate measures if I need to.
Thanks againPaul- Ashish_Mathur
Hi,
I do not work with variables so i would not be able to help.
- Otto_Luvpuppy
No problem...thanks for you help on this.