Forum Discussion
Calculation: Row Subtotal
Hi Chirantan
You may try to use IF Function to change the total of the Matrix. There're some cases for your reference as below. By the way, you may close the row subtotal from 'Format'->'Subtotal'->'Row subtotals'.
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
For example:
Measure = IF ( SUMX ( FILTER ( ALL ( Table1 ), Table1[date] = DATE ( 2014, 6, 30 ) ), Table1[Value] ) = SUM ( Table1[Value] ), 1, 0 )Regards,
Cherie
Hi Chirantan,
I am new to Power BI and I have a similar request like yours.I have a row called 'Segments' and three calculated columns grouped by three different plants.
Now, I want to have a calculated row 'Custom Segment'(adding two of the segments )which will then show the corresponding values ( All three calculated columns) plant wise. Below is a screenshot of my matrix. Could you please assist me with this?
Regards,
Gunjan