Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Nino1
Frequent Visitor

Creating Calculation using Selected Value function

Hello Everyone,

It's not been a long time I started using Power BI and need your help.

I have two measures: "sum of portfolio with nominal values" and "sum of portfolio with adjusted currency value". Also, I have Slicer filter called Currency adjustment that has 2 values: "Yes" and "No" and  I want to create vizualization so that if I select filter and choose "Yes" , "sum of portfolio with adjusted currency value" should be shown on vizualization and  if I select filter and choose "No", "sum of portfolio with nominal values"  should be shown on vizualization.

I tried to create a measure using selectedvalue function but could not deal with it. Could you please help how can I solve this problem?

 

Thank you 

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

Use the below dax it will work

VAR SelectedValue = SELECTEDVALUE(CurrencyAdjustment)

RETURN
SWITCH(
SelectedValue,
"Yes", SUM('Portfolio'[AdjustedCurrencyValue]),
"No", SUM('Portfolio'[NominalValue])
)

View solution in original post

Thank you very much, it works !

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Use the below dax it will work

VAR SelectedValue = SELECTEDVALUE(CurrencyAdjustment)

RETURN
SWITCH(
SelectedValue,
"Yes", SUM('Portfolio'[AdjustedCurrencyValue]),
"No", SUM('Portfolio'[NominalValue])
)

Thank you very much, it works !

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.