Forum Discussion

ewwpoewpeoweo's avatar
ewwpoewpeoweo
New Member
2 years ago
Solved

Create slicer based on measure

Hi, all! I stacked with a problem, need some hints Have two tables (see below) in my Data Model. I need to create measures that calculate Value Sales and displays value based on currency select...
Need Help
  • AliceW's avatar
    AliceW
    2 years ago

    Try something like this:

    Step one: create a little table called 'Currency' with one column and with one line per each currency you need.

    Step two: create this measure

    Amount =
    SWITCH(
        TRUE(),
            SELECTEDVALUE('Currency'[Currency])="EUR",sum('Table'[EUR]),
            SELECTEDVALUE('Currency'[Currency])="CHF",sum('Table'[CHF])
    )
    Step three: add the Currency table column as a slicer
    Step 4: insert the measure
AliceW's avatar
AliceW
Power Participant
2 years ago

Try something like this:

Step one: create a little table called 'Currency' with one column and with one line per each currency you need.

Step two: create this measure

Amount =
SWITCH(
    TRUE(),
        SELECTEDVALUE('Currency'[Currency])="EUR",sum('Table'[EUR]),
        SELECTEDVALUE('Currency'[Currency])="CHF",sum('Table'[CHF])
)
Step three: add the Currency table column as a slicer
Step 4: insert the measure