Forum Discussion
Totals Calculations using a % - a real problem
Hi,
Try this measure
Measure = SUMX(VALUES(Pipelime_MFMA[Project]),[Year 1 Adjusted by Probability])
Hope this helps.
Hi,
Try this measure
Measure = SUMX(VALUES(Pipelime_MFMA[Project]),[Year 1 Adjusted by Probability])
Hope this helps.
Hi 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
Mine is a new measure.
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
Hi Ashish_Mathur - I had the same issue and this solution gives me the right result. However the Project field in my case is a field parameter. For example my measure is -
Measure Final =
var _total =
IF(HASONEFILTER(WD_Dim[L3]),[Measure Interim],
SUMX(VALUES(WD_Dim[L3]),[Measure Interim]))
return _total
This gives right result, but based on field paramater it can be L3, L2 field etc from the WD_Dim table , so how do i tweak the above measure to get that result?Hi Otto_Luvpuppy ,
Currently you cannot use Field parameters to change your table dynamicaly, only option would be to do SUMX for each of the values in the field parameters.
Thank you for your reply. That's clear. However I do have a related question and would be great if you can help. I have measure generated using formula (1-B) * A. The values appear right in Measure and I show them as % of column total using power bi functionality to show calc as % of column total in visualization pane.
However I want to achive same thing using measure. so I want a measure in DAX to show me same resultset as % of column total and could you please help. Result is measure value / grand total column of column, so 345,5/463,7 = 74,5%
Hi,
I am not sure how much i can help but i can try. Share the download link of the PBI file. Show the visual clearly in which you have dragged the measure and would like to incorporate the change.
