Forum Discussion
DAX Calculations
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...
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.