Forum Discussion

nesisekasi's avatar
nesisekasi
New Member
3 years ago
Solved

Measure that sums different columns as values based on filter

I am trying to create a measure which sums values of different columns based on filter. Say I have 2 tables: Currency table CurrencyCode USD EUR   Sales table RevenueUSD RevenueE...
Need Help
  • pradeep08's avatar
    pradeep08
    3 years ago

    Hello nesisekasi,

    Please find the below solution that works. Also, please note this will work only for Single Selection in the Filter:

    Here is the formula for the measure:

    DynamicRevenue_Sum =
    -- Creating variables for each sum
    VAR USD_SUM = SUM(Sales[Revenue_USD])
    VAR EUR_SUM = SUM(Sales[Revenue_EUR])
    -- Identifying Selected Value from the filter
    VAR SelectedFilter = SELECTEDVALUE('Currency'[CurrencyCode])
    RETURN
    -- Returning sum value based on the selection
    IF(SelectedFilter = "USD", USD_SUM, EUR_SUM)


    Please mark this as solution if it helps.
    Thank you,

    Pradeep Chowdavarapu
    "Even if no one believes you can,

    YOU GOT TO BELIEVE YOU CAN."

pradeep08's avatar
pradeep08
New Member
3 years ago

Hello nesisekasi,

Please find the below solution that works. Also, please note this will work only for Single Selection in the Filter:

Here is the formula for the measure:

DynamicRevenue_Sum =
-- Creating variables for each sum
VAR USD_SUM = SUM(Sales[Revenue_USD])
VAR EUR_SUM = SUM(Sales[Revenue_EUR])
-- Identifying Selected Value from the filter
VAR SelectedFilter = SELECTEDVALUE('Currency'[CurrencyCode])
RETURN
-- Returning sum value based on the selection
IF(SelectedFilter = "USD", USD_SUM, EUR_SUM)


Please mark this as solution if it helps.
Thank you,

Pradeep Chowdavarapu
"Even if no one believes you can,

YOU GOT TO BELIEVE YOU CAN."