Forum Discussion

PowerBINoob321's avatar
PowerBINoob321
New Member
3 years ago
Solved

Slicer - Selecting multiple items messes up total value

Hope someone can help. Basically, I have a few sources of data in foreign currencies which I combine.  I also have a list of exchange rates.  So to get all the values in the same currency, I simpl...
Need Help
  • NikhilChenna's avatar
    NikhilChenna
    3 years ago

    Hi PowerBINoob321 ,

    Firstly you have to bring the conversionrate in to your combined table by creating a calculated column using lookup value funtion based on the country.

    After that you can create another column for conversion simply you can say , 

     

    BudgetsPowerBI[Value]*BudgetsPowerBI[Conversion]

     

    This should help.

     

    Regards,

    Nikhil Chenna

     

    Appreciate with a Kudos!! (Click the Thumbs Up Button)
    Did I answer your question? Mark my post as a solution!

NikhilChenna's avatar
NikhilChenna
Skilled Sharer
3 years ago

Hi PowerBINoob321 ,

Firstly you have to bring the conversionrate in to your combined table by creating a calculated column using lookup value funtion based on the country.

After that you can create another column for conversion simply you can say , 

 

BudgetsPowerBI[Value]*BudgetsPowerBI[Conversion]

 

This should help.

 

Regards,

Nikhil Chenna

 

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

NikhilChenna's avatar
NikhilChenna
Skilled Sharer
3 years ago

Hi PowerBINoob321 , If this works.

Please Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Please Mark my post as a solution!