Forum Discussion
How to remove data from specific levels in Matrix Visual?
Good Afternoon All, I am hoping this is a simple question to answer but after spending a ton of time searching the web for answers, it was time to break down and ask the geniuses that visit this ...
After further digging, i found an article that was asking the same thing i was but worded differently. After trying the solution for that one i determined it was the same as my question. you will need to use something similar to the below measure:
Measure Name = if(ISINSCOPE('QueryName'[column name]),max('QueryName'[valuecolumn]),"-")
So for my example above, i wrote the following:
Property Type = if(ISINSCOPE('Portfolio Details'[AssociationName]),max('Portfolio Details'[Association Type]),"-")
This allowed me to state the only time the property type show was in the Association level since that was now the scope i was looking for. Hope this helps anyone else looking at this post for answers 🙂
Have an amazing day everyone!