Power BI Matrix with one measure only showing on the first field in rows and the 2nd on 2nd field

[Brutus97]

Hello,

I want to make a matrix that gives the availability of an item per day. Today is 12-01. It looks like this:

                                                12-01                          13-01                          14-01

Item A(1st level)                            10                               7                                  12         

(exp)

     inventory   (2nd level)               7                               0                                     0

     purch order (2nd level)              4                               3                                     8

     sales orders (2nd level)            -1                              -6                                    -3

I have a measure in the matrix that calculates the value for the first level.  That goes well, but I don't want it to be visible on the expand to the second level (inventory, purchase orders and sales orders). On the second level I only want to show the measure that gives the changes on that day. I have made the measures, with running total and filters, they are correct. But when I put them in the matrix, it  always shows all measures on all levels...

Does anyone have a smart solution for this?

Thank you in advance!

[parry2k · Accepted solution]

@Brutus97 you can take advantage of ISINSCOPE function and drive the logic for each level of the hierarchy, check few videos on my YT channel on this function

Let's explore the underrated ISINSCOPE DAX function - What is it? How we can use it? - YouTube

ISINSCOPE & ISFILTERED DAX functions give the same result-learn why use one over another- Power BI -...

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort 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.