Forum Discussion
How to remove subtotal in Matrix for specific level
Hi kala2 ,
After replacing the created measure with the value in the matrix, you need to set the conditional judgment in the conditional formatting to be effective.
just like:
If there are still problems, please provide a test data model (delete sensitive information), otherwise no further testing can be done if only screenshots are provided.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi v-henryk-mstf , thanks for the info!
I have applied your measure. I made some modifications in your measure. I changed the MAX to SUM since i want the sum of all the values. Below is the changed measure:
The problem still persists since it highlights the months and the year as a red color.
Hi kala2 ,
After replacing the created measure with the value in the matrix, you need to set the conditional judgment in the conditional formatting to be effective.
just like:
If there are still problems, please provide a test data model (delete sensitive information), otherwise no further testing can be done if only screenshots are provided.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.