Forum Discussion
Display Measure based on selection in slicer
I am new to Power BI and need some help with something which seems pretty easy in theory.
I am displaying data in a matrix table which shows items and sales numbers. I have created separate measures for each currency value and I need to display the currency value based on a selection from a slicer.
I created a table which is used for the Currency slicer containing the below values
| AUD |
| NZD |
Based on the selection in the slicer (AUD or NZD) I want to use the corresponding measure in my matrix view table for the Sale column.
| Item | Sale |
| AAA | 1000 |
| BBB | 3000 |
| CCC | 1500 |
In pesudo code I want to acheive this:
IF(selected value in slicer = "AUD") then
Use the SaleAUD measure
ELSE IF(selected value in slicer = "NZD") then
Use the SaleNZD measure
ELSE
Use the SaleAUD measure
How would I acheive this in Power BI
-M.
Hi martinnilsson , Since you have already created Table could you try this
1 . Create Table
2 . Add that table to slicer
3 . Create a Dyanmic Measure :
SelectedSales =
SWITCH(
TRUE(),
SELECTEDVALUE(Currency[Currency]) = "AUD", [SaleAUD],
SELECTEDVALUE(Currency[Currency]) = "NZD", [SaleNZD],
[SaleAUD]
)
Replace Currency[Currency] with your coulmn
4 . Add this measure to matrix with item column
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
2 Replies
Hi martinnilsson , Since you have already created Table could you try this
1 . Create Table
2 . Add that table to slicer
3 . Create a Dyanmic Measure :
SelectedSales =
SWITCH(
TRUE(),
SELECTEDVALUE(Currency[Currency]) = "AUD", [SaleAUD],
SELECTEDVALUE(Currency[Currency]) = "NZD", [SaleNZD],
[SaleAUD]
)
Replace Currency[Currency] with your coulmn
4 . Add this measure to matrix with item column
If this post helped please do give a kudos and accept this as a solution
Thanks In AdvanceHi martinnilsson - You can achieve this using a DAX measure that dynamically switches between the SaleAUD and SaleNZD measures based on the slicer selection.
when you selected aud,
Please find the attached pbix file.
