dividing row values with subtotal

[Anonymous]

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

    

[Dangar332]

Hi, @Anonymous 

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)

[Anonymous]

not working

[Dangar332 · Accepted solution]

Hi, @Anonymous 

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

[Anonymous]

Thank You so much....

[VBLOT]

Hello @Anonymous ,

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!

[Anonymous]

not working sir