Forum Discussion
danmone
4 years agoFrequent Visitor
show different fields depending on matrix level
Hi I have a matrix setup to show sales, the colums are start of month which can be drilled down to show the various sales channels, which can then be drilled down to individual customer and then...
parry2k
4 years agoSuper User
danmone You can isinscope to check the level you are at and based on it return blank value in the measure otherwise return value. New DAX function: ISINSCOPE – XXL BI
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡