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

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