Forum Discussion

martinnilsson's avatar
martinnilsson
Frequent Visitor
1 year ago
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...
Need Help
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    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

Akash_Varuna's avatar
Akash_Varuna
Icon for Super User rankSuper User
1 year ago

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