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 IIAshish,
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 * _Chance
RETURN
SUMX(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 again
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 again
Paul
Ashish_Mathur
Super User
Super UserHi,
I do not work with variables so i would not be able to help.
- Otto_Luvpuppy
No problem...thanks for you help on this.