Forum Discussion
Helper Iissue in matrix table regarding the level
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
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
2 Replies
- amitchandak
Super User
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 
v-lili6-msftCommunity Support
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
