Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
i want to divide each row of TY_Actual with its subtotal i.e 110679.54 to get the %. i created 1 measure and it was showing correct value but the catch was the value was getting displayed in total row rest rows were empty
Solved! Go to Solution.
Hi, @MorningStar_92
sorry, in above code there are some changes needed and i forgot to write it
try below code
result =
var a = sum('yourtablename'[TY_Actual])
var b = calculate ( sum('yourtablename'[TY_Actual],
removefilters('yourtablename')
)
return
divide(a,b)
if it not work then provide some sample data
Hi, @MorningStar_92
try below code
just adjust your table and column name
result =
var a = sum('yourtablename'[TY_Actual])
var b = calculate ( sum('yourtablename'[TY_Actual],
removefilters('yourtablename')
)
return
divide (a,b)
not working
Hi, @MorningStar_92
sorry, in above code there are some changes needed and i forgot to write it
try below code
result =
var a = sum('yourtablename'[TY_Actual])
var b = calculate ( sum('yourtablename'[TY_Actual],
removefilters('yourtablename')
)
return
divide(a,b)
if it not work then provide some sample data
Thank You so much....
Hello @MorningStar_92 ,
Could you give more info on the measure you tried ?
In a first look, I could suggest in your measure to calculate the SUM of TY_Actual filtering by DayPart, and to calculate the same SUM but selecting all your table with ALL or ALLSELECTED depending on your need.
Then you can divide the filtered sum by the second and format your measure as %.
It could look like :
MyPercentage =
VAR FilteredSum = CALCULATE (
SUM('YourTable'[TY_Actual],
FILTER('YourTable', 'YourTable'[Daypart] = SELECTEDVALUE('YourTable'[Daypart])
)
VAR GlobalSum = SUM('YourTable'[TY_Actual])
RETURN DIVIDE(FilteredSum, GlobalSum)
Hope it helps
Vincent BLOT
Did I answer your question? Mark my post as a solution!
not working sir