Forum Discussion

sonuojha1's avatar
sonuojha1
Helper IV
5 years ago
Solved

Slicer to get Multiple selected values

Subject: Slicer to get Multiple selected values and use those values in Variables inside measures Hi All, I have a requirement to use slicer's selected multiple values to use to compare different s...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    sonuojha1 , Not very clear try like

     

    Measure =
    var _min = minx(allselcted('Table'),'Table'[selections])
    var _max = maxx(allselcted('Table'),'Table'[selections])
    return
    Switch( True(),
    _max = "ActualThisYear" ,[ActualThisYear],
    _max = "ActualLastYear" ,[ActualThisYear]
    // Add Other
    ) - Switch( True(),
    _min = "ActualThisYear" ,[ActualThisYear],
    _min = "ActualLastYear" ,[ActualThisYear]
    // Add Other
    )

amitchandak's avatar
amitchandak
Super User
5 years ago

sonuojha1 , Not very clear try like

 

Measure =
var _min = minx(allselcted('Table'),'Table'[selections])
var _max = maxx(allselcted('Table'),'Table'[selections])
return
Switch( True(),
_max = "ActualThisYear" ,[ActualThisYear],
_max = "ActualLastYear" ,[ActualThisYear]
// Add Other
) - Switch( True(),
_min = "ActualThisYear" ,[ActualThisYear],
_min = "ActualLastYear" ,[ActualThisYear]
// Add Other
)