Forum Discussion
Solved
How to disable sub totals for string values on matrix visual?
I have a report I am developing using the matrix visual that has two columns from my dataset in the rows column, RowColumnOne and RowColumnTwo, which are both strings. I also have several columns fro...
Zak-Echelon is ISINSCOPE dax function to achieve this. There is a great post on it.
parry2k
Super User
Super UserZak-Echelon did you had chance to go thru the post I sent to you earlier, you will wrap your existing measure in If or switch condition so that it doesn't show the text on total.
I figured out the issue. I was using ISINSCOPE on the wrong columns. I was originally calling ISINSCOPE on the string value column, when I should have been calling it on the sub group column. Once I made that switch, everything works as expected.
Thanks for the help!