Forum Discussion
Helper IITotals Calculations using a % - a real problem
Hi,
Try this measure
Measure = SUMX(VALUES(Pipelime_MFMA[Project]),[Year 1 Adjusted by Probability])
Hope this helps.
Helper IIHi Ashish,
Thanks for your repsonse.
I'm not quite sure how this would work as the final part of your measure references itself...so doesn't that make it a circulare reference?
Paul
Super UserMine is a new measure.
- Otto_Luvpuppy
Hi 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
Yes.
- 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
- Otto_Luvpuppy
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
You are welcome.