Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Using sublevel matrix row as a filter

Hi,   I have quite a specific question for which I can't seem to find an answer, if there is. In my report I use a matrix as a central visual, with several visuals around it that filter along with ...
Need Help
Tips and Tricks
  • parry2k's avatar
    parry2k
    4 years ago

    Anonymous, unfortunately, there is no direct way, but you can write measures that ignore top-level categories and just filter on 3rd level category (in this case Direct)

     

    For example:

     

    Measure = CALCULATE ( SUM ( Table[Amount] ), REMOVEFILTERS ( Table[Level1], Table[Level2] ) )

     

    ✨ Follow us on LinkedIn

     

    Check 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.⚡

parry2k's avatar
parry2k
Super User
4 years ago

Anonymous If I understood your question correctly if you click on Direct, you want to ignore top-level categories (Debit/Active and Credit/Active) and show the value of Direct in all other visuals on the same page. I guess currently when you click on Direct under Debit/Active, it filters other visuals for Debit/Active/Direct. Is this correct understanding?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi, yes this is exactly correct.

 

In another visual, I have split everthing out between Debit and Credit and I want to show the amounts linked to Direct (regardless of top level categories) next to eachother. Now, one of the columns is empty because you filter for Debit/Active/Direct.