Forum Discussion
Matrix Drill up text filter
Hi everyone, I am working with a matrix that goes from account -> account group (think fast food would have burger king, mcdonalds, wendy's, but it would just be labeled fast food) -> account manager -> their manager -> their manager and so on.
The problem is, I have a URL measure that needs to be blank when at the account manager level and above. It should however, work at the account level and the account group level. I have tried everything (it feels like). Calculate function with all, summarize, cross join. I don't know if I'm just not using them right or what. Almost all of the manager fields are in different tables, so if I can filter it out, it's going to be a longgg function.
Let me know what you think and if this is even possible.
Thank you in advance you wonderful people 🙂
Hi Anonymous ,
Based on your description, I have created a simple sample:
Please try:
Measure = IF(ISINSCOPE('Table'[Account Group]),MAX('Table (2)'[URL]),BLANK())Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
v-jianboli-msftCommunity Support
Hi Anonymous ,
Based on your description, I have created a simple sample:
Please try:
Measure = IF(ISINSCOPE('Table'[Account Group]),MAX('Table (2)'[URL]),BLANK())Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- v-jianboli-msft
Hi Anonymous ,
It works fine in my side, showing at account level. Maybe I misunderstood?
If I misunderstood, please give more details about your table and your problem or share me with your pbix file after removing sensitive data.
Refer to:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.