Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
Show and Tell
Tips and Tricks
  • Icey's avatar
    Icey
    6 years ago

    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.