Matrix: Result of a measure only in subtotal rows

[Jan_Trummel]

Hello community,

I have a Matrix visual and I only want to show the result of a measure for a subtotal row.

Is that possible? 

In the visual, I have the fields year, quarter, month and date in rows.

The result should only appear for the months.

Greetings

[Jan_Trummel]

Tank you, selimovd!

That should work!

[selimovd · Accepted solution]

Hello @Jan_Trummel ,

yes, you can check if a certain level is in scope or if it's summarized.

Check out the ISINSCOPE function for that.

If you give more details I can also help you to find a solution.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi