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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

not working

 

Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank You so much....