Forum Discussion
Using variable slicer to filter multiple columns of a table
I need a dynamic slicer (week number of the year) to filter 6 columns (6 charts) of values above the slicer value.
I tried to create a parameter to use in the slicer with a starter value of 1, end value of 53 and an increment of 1 with a default value of 53: Parameter Week = GENERATE SERIES(1, 53, 1) Parameter Week Value = SELECTED VALUE('Parameter Week'[Parameter Week], 53)
and with that created a new column like: Column= IF(table1[column A]>= Parameter Week [Parameter Week value],1,0).
I put a card to give the actual value of the Parameter Week value which is currently at 37 and the values are being filtered at >=53 which is the default value. What am I missing?
I tried to use a measure instead of a column like: Measure = IF(table1[column A]>= Parameter Week [Parameter Week value],1,0)
but I'm getting an error of: A single value for column 'Column A' in table 'Table1' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
TIA
I will throw this out there...What if you try SUMX?
Measure = IF(SUMX(table1,table1[column A])>= Parameter Week [Parameter Week value],1,0)
4 Replies
- MP-iCONNResolver I
I might be way off but wouldn't the Parameter Week Value measure be this....
Parameter Week Value = SELECTEDVALUE('Parameter Week'[Parameter Week], 53)