Forum Discussion
Solved
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 measure...
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
rajendraongole1
Super User
Super UserHi 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.