Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I have the following situation:
In my model there are 2 Tables "Hierachy" and "Values" that look roughly like this:
The Result Table i want to achive should look like this:
As the Calculations in the Hierachy are not just SUM(Previous Hierachy Level) i calculate the Values in Measures:
The results for the measures are fine. But i do not know how i get to my Result Table showing the Labels of different Hierachy Levels in one Column and the inherent values in another Column. What i tried was to do is:
Values = SWITCH(SELECTEDVALUE(Label), "AUM", [AUM], ....)
But this didnt work out.
Can anyone help me here please?
Regards
Dennis
Solved! Go to Solution.
Hi @Anonymous ,
Sorry to reply late.
It is suggested to enter data to create a MeasureName table.
And then create measures like so:
Sum =
SWITCH (
SELECTEDVALUE ( MeasureTable[MeasureName] ),
"AUE", [AUE],
"AUM", [AUM],
"BUVE", [BUVE],
"LPVKBW", [LPVKBW],
"NU", [NU],
"FOWE", [FOWE],
"FOMI", [FOMI]
)
Sum% =
SWITCH (
SELECTEDVALUE ( MeasureTable[MeasureName] ),
"AUE", [AUE]/100000,
"AUM", [AUM]/100000,
"BUVE", [BUVE]/100000,
"LPVKBW", [LPVKBW]/100000,
"NU", [NU]/100000,
"FOWE", [FOWE]/100000,
"FOMI", [FOMI]/100000
)
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @Icey ,
This is going in the direction i want it to be, thank you. Can you tell me if i can now get a heading for these columns? And what if i need another column? Like the % of the value (value / X)?
Regards,
Dennis
Hi @Anonymous ,
Sorry to reply late.
It is suggested to enter data to create a MeasureName table.
And then create measures like so:
Sum =
SWITCH (
SELECTEDVALUE ( MeasureTable[MeasureName] ),
"AUE", [AUE],
"AUM", [AUM],
"BUVE", [BUVE],
"LPVKBW", [LPVKBW],
"NU", [NU],
"FOWE", [FOWE],
"FOMI", [FOMI]
)
Sum% =
SWITCH (
SELECTEDVALUE ( MeasureTable[MeasureName] ),
"AUE", [AUE]/100000,
"AUM", [AUM]/100000,
"BUVE", [BUVE]/100000,
"LPVKBW", [LPVKBW]/100000,
"NU", [NU]/100000,
"FOWE", [FOWE]/100000,
"FOMI", [FOMI]/100000
)
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , see if this can help
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |