Do not show the first row values when expanded using matrix

Anonymous , Not very clear. But isinscope should able to help you

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

having the same issue here... did you finally figured it out?

Anonymous

I have the same problem, did you find any solution for it?

Hi there,

I've managed to find a workaround for this. It's not the best but it's a very simple procedure. First of all, you have to know the main colors of your report. 

So you go to the "Cell elements" property of your matrix, enable "Font color" and in the 'fx' button you have to configurate accordingly to your report colors. You set the collapsed value to be the same color as your background (in my example, white) and the expanded to be the one you want for your fonts.

Set the range based on your data (in this case I've put anything between 2 and 40), remembering that for PowerBI this means the total count of the subrows under the main row. The other rule you set to "1" since the count will be allways 1 when you expand the rows (you have to be using two-level matrix to work exactly like above). 

It'll be something like this:

Regards,

Mr. Barbosa

I have the same issues nearly 4 years later. Cannot believe they don't have like a "Show Values when collpsed" toggle. It can be very confusing for the user if you are utilizing descriptive data instead of numeric data.

Hope something pops up soon!