Forum Discussion
Solved
Multiple Selection for Slicer/Parameter
Hi - I have a time based measure that calculates a "Risk" metric based on several other attributes which change over time. I'd like to add a slicer which allows multi-select like the one...
HI facilitydax ,
Did your slicer use the same source field as your snapshot? If this is a case, you can direct use values(Table[Risk]) as a filter condition to filter calculation records.
Measure = CALCULATE ( formula, VALUES ( Table[Risk] ) )If your slicer uses an unrelated table column as the source, you can loop the whole table to compare it with selected items.
Measure = CALCULATE ( formula, FILTER ( ALLSELECTED ( Table ), Table[Risk] IN VALUES ( selector[Risk] ) ) )Regards,
Xiaoxin Sheng
HI facilitydax ,
Did your slicer use the same source field as your snapshot? If this is a case, you can direct use values(Table[Risk]) as a filter condition to filter calculation records.
Measure =
CALCULATE ( formula, VALUES ( Table[Risk] ) )
If your slicer uses an unrelated table column as the source, you can loop the whole table to compare it with selected items.
Measure =
CALCULATE (
formula,
FILTER ( ALLSELECTED ( Table ), Table[Risk] IN VALUES ( selector[Risk] ) )
)
Regards,
Xiaoxin Sheng