Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

dividing row values with subtotal

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 ro...
  • Dangar332's avatar
    Dangar332
    2 years ago

    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

VBLOT's avatar
VBLOT
Icon for Helper I rankHelper I
2 years ago

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's avatar
    Anonymous
    Not applicable
    2 years ago

    not working sir