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 budget at level 5? Is there anything that i do wrong?

 

 

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
     

4 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    5 years ago

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

    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
     
    • 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