Sub Row total

Question

Hi ,I have a simple requiremet to add a measure as row subtotal.I am creating a matrix in Power Bi, where I need a measure.In product name the first one is refrigerator whose sum of all equipments is 67,so new measure total by product name should display only 67.Moreover if I filter any equipment like removing a for refrigerator the measure shoulddisplay 67-12=55 value.&nbsp;I tried to use calculate( sum(table[price]), removefilters(table[equipment]) and&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;calculate( sum(table[price]), allexcept(table[equipment]) but didn;t work.Thanks&nbsp; for HelpNobie.&nbsp;

rajulshah · Answer

Nobie&nbsp;&nbsp;Power BI does this implicitly, I don't think you would need to add any extra DAX functions here.You can just use SUM and you would be able to get the required value in MATRIX in Power BI&nbsp;Please let me know if this is not working. You can provide the screenshot or sample data.

vijayp · Answer

Nobie&nbsp;
Please let me know whether you want this result as per the file attached
&nbsp;

nobie · Answer

thanks, i got the solution we can normaly do with dax&nbsp;calculate( sum(table[price]), allselect(table[equipment]))

nobie · Answer

thanks, i got the solution we can normaly do with dax&nbsp;calculate( sum(table[price]), allselect(table[equipment]))

Forum Discussion

Sub Row total

4 Replies

Related content

DAX total != total rows

custom total row

Getting Totals On Each Row

Matrix Row Totals

Background color for each Row Total + Row Headers also