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

Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

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'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....