issue in matrix table regarding the level

[aravindh10]

I have a situation where i have 3 row headers in matrix table namely segment,series and model.The value i want to show is only for segment level .so i want the series and model level should be blank but now i am having the segment,model,series data is same.help me with this

[v-lili6-msft · Accepted solution]

hi, @aravindh10 

You could use ISINSCOPE Function to create a measure like this to get it.

Measure = IF(ISINSCOPE('Table'[series])||ISINSCOPE('Table'[model]),BLANK(),SUM('Table'[Value]))

result:

And here is sample pbix file, please try it.

Best Regards,

Lin

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example. If possible please share a sample pbix file after removing sensitive information.
Thanks