DIsplay values only at first level of drill down in Matrix Table

[Miska]

Is it possible to display the values for a particular column in matrix table only at the first level of drill down and blank in the cells below. I have a Matrix table with rows Sales Lines, PC Number and Gl Numbers and in the Values I have 4 columns. For one particular column which is a text field , I want to display that text only at the Sales Lines level and everything under that should show as blank. Currently when drilling down it displays the same text in all the cells below for that PC.

Help will be greatly appreciated.

Thanks

[parry2k · Accepted solution]

@Miska You can use ISINSCOPE function to check the level, read more here

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

[aamirkhan_WT]

Hi 

I am facing issue to display in first level in Matrix table screenshot below. If you provide the solution it will be helpful for me . f you provide the me dax that will be great

[v-rzhou-msft · Accepted solution]

Hi @Miska 

Here I build a sample to show you how to only show text in level1 and other levels show blank.

My Sample:

Measure:

TEXT ONLY SHOW IN LEVEL1 =
SWITCH (
    TRUE (),
    ISINSCOPE ( 'Table'[Level4] ), BLANK (),
    ISINSCOPE ( 'Table'[Level3] ), BLANK (),
    ISINSCOPE ( 'Table'[Level2] ), BLANK (),
    ISINSCOPE ( 'Table'[Level1] ), MAX ( 'Table'[TEXT] ),
    BLANK ()
)

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k · Accepted solution]

@Miska You can use ISINSCOPE function to check the level, read more here

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