Using value from allselected in a measure to filter rows in another measure

Viewed 14

I want to use the selected slicer value in string format to filter rows in a table in a visual.

So, I created the following measure:

SlicerVal = ALLSELECTED(Table[Column1])

The follow up measure is as follows:

TotalRows = CALCULATE(COUNTROWS(Table),filter(Table, Table[Column2] = [SlicerVal]))

However.. This returns completely different data. When hardcoding the string value the correct data is returned, like in the example below:

TotalRows = CALCULATE(COUNTROWS(Table),filter(Table, Table[Column2] = "A"))

Is there a way to convert the measure value to a string somehow, which can be used dynamically to correspond the string value filter to the selected slicer value?

0 Answers
Related