Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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] )
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.
Proud to be a Super User!
Hey @matthijs ,
you can check with the function ISINSCOPE if the desired level is in scope.
If yes, then return blank, otherwise the budget.
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 @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] )
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |