Forum Discussion
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 row rest rows were empty
Hi, Anonymous
sorry, in above code there are some changes needed and i forgot to write it
try below coderesult = 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
6 Replies
- VBLOTHelper I
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!- AnonymousNot applicable
not working sir
- Dangar332Resident Rockstar
Hi, Anonymous
try below code
just adjust your table and column nameresult = var a = sum('yourtablename'[TY_Actual]) var b = calculate ( sum('yourtablename'[TY_Actual], removefilters('yourtablename') ) return divide (a,b)- AnonymousNot applicable
not working
- Dangar332Resident Rockstar
Hi, Anonymous
sorry, in above code there are some changes needed and i forgot to write it
try below coderesult = 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