Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
Use the below dax it will work
VAR SelectedValue = SELECTEDVALUE(CurrencyAdjustment)
RETURN
SWITCH(
SelectedValue,
"Yes", SUM('Portfolio'[AdjustedCurrencyValue]),
"No", SUM('Portfolio'[NominalValue])
)
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 !
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |