Forum Discussion
Matrix - Is it possible to make particular rows blank?
Hi all
I just was wondering if it is possible to not have anything show in particular rows of my matrix. For example below, i only want the 'y' to be in the row of the employees name, but it appears to come up in each of the previous tabs before it.
Is it possible to get it so the 'Y' only shows up when you get to the employee name, and not in the rows previous? Preference would be that the rows beforehand are just blank
Hope this makes sense.
Thankyou
Hi Michael11
Thanks for reaching out to us.
>> The bolded "Y" is because the row subtotal function is enabled by default, you can disable this option
try
result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
Michael11 , Not very clear. But isinscope can help
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
- v-xiaotang
Community Support
Hi Michael11
Thanks for reaching out to us.
>> The bolded "Y" is because the row subtotal function is enabled by default, you can disable this option
try
result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.