Forum Discussion

yawerkhan's avatar
yawerkhan
New Member
6 years ago
Solved

Currnecy Converting Filter

hi Team,   i have a report in Dollars, and i need to create a filter to select if i need to see all values in Dollars as is, OR convert it to Euros if i select euros. i can have another table with...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi yawerkhan ,

     

    Please check following steps as below.

    1# Create a conversion rates table and add Currency as slicer.

    2# Create a measure as below.

    Measure = IF(NOT(ISFILTERED('conversion rates'[Currency])),SELECTEDVALUE('Table'[sales]),SELECTEDVALUE('Table'[sales])*SELECTEDVALUE('conversion rates'[rates]))

    Result would be shown as below.

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi yawerkhan ,

 

Please check following steps as below.

1# Create a conversion rates table and add Currency as slicer.

2# Create a measure as below.

Measure = IF(NOT(ISFILTERED('conversion rates'[Currency])),SELECTEDVALUE('Table'[sales]),SELECTEDVALUE('Table'[sales])*SELECTEDVALUE('conversion rates'[rates]))

Result would be shown as below.

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.