Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
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
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |