Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    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 regards
    Denis
     
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
selimovd
Most Valuable Professional
5 years ago

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 regards
Denis