Forum Discussion
Hierarchy problem
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 bu...
Hey Anonymous ,
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 regardsDenisBlog: WhatTheFact.bi
Hey Anonymous ,
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
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?
Hey Anonymous ,
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 regardsDenisBlog: WhatTheFact.bi