Hierarchy problem

[matthijs]

Hello,

I have a problem with my hierarchy. I have two diferrent tables in PowerBI in one matrix. The hierarchy is in total five levels, but the budget is at level four. How do i get rid of the budget at level 5? Is there anything that i do wrong?

[vanessafvg]

its really hard to understand what is occuring with the information you have provided, firstly demonstrate what your hierarchy is, then please demonstrate what you expect.    one woudl need to see the data to understand what is going on.

[selimovd]

Hey @matthijs ,

you can check with the function ISINSCOPE if the desired level is in scope.

If yes, then return blank, otherwise the budget.

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

[matthijs]

hello thanks for your answer.

everything that is true (waar) must be empty and otherwise it must fills in the budget. do i need for this an if formula or how do i do this?

[selimovd · Accepted solution]

Hey @matthijs ,

I mean you don't show anything, just 5 rows with "Waar" and 2 with "Onwaar".
Show the measure, show how the table looks, show your matrix.

Otherwise, check:

myMeasure = IF( [thisWaarMeasure] = "Waar", BLANK(), [thisWaarMeasure] )

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