Forum Discussion
matrix subtotal formatting
Anonymous
That's not a problem. What field are you using in rows of your matrix visual? That is the one you have to use in ISFILTERED( ). That's what I meant by
ISFILTERED ( Table1[ColumnInRowsOfTheMatrix] )
Using it like that, the ISFILTERED tells you where you are in the matrix visual, Total or not Total.
If you share the pbix or at least show the structure of your table(s), the code of your measure and how you build the matrix visual where you use the measure (i.e. what fields go where) I will be able to help you further.
Anonymous
That's not a problem. What field are you using in rows of your matrix visual? That is the one you have to use in ISFILTERED( ). That's what I meant by
ISFILTERED ( Table1[ColumnInRowsOfTheMatrix] )
Using it like that, the ISFILTERED tells you where you are in the matrix visual, Total or not Total.
If you share the pbix or at least show the structure of your table(s), the code of your measure and how you build the matrix visual where you use the measure (i.e. what fields go where) I will be able to help you further.
Ah! So what I wanted was the column subtotals rather than the row subtotals, and as I had the row subtotals switched off I didn't see that it was actually working. I managed to amend it so the column to filter on was correct to format the total column, thank you!