topic Re: dividing row values with subtotal in DAX Commands and Tips

dividing row values with subtotal

Anonymous — Mon, 06 Nov 2023 11:28:01 GMT

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

Re: dividing row values with subtotal

VBLOT — Mon, 06 Nov 2023 11:40:54 GMT

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!

Re: dividing row values with subtotal

Dangar332 — Mon, 06 Nov 2023 13:11:40 GMT

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)

Re: dividing row values with subtotal

Anonymous — Mon, 06 Nov 2023 12:59:20 GMT

not working sir

Re: dividing row values with subtotal

Anonymous — Mon, 06 Nov 2023 12:59:53 GMT

not working

Re: dividing row values with subtotal

Dangar332 — Mon, 06 Nov 2023 13:11:04 GMT

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

Re: dividing row values with subtotal

Anonymous — Tue, 07 Nov 2023 09:14:49 GMT

Thank You so much....