Forum Discussion
Filter data in table based on silcer
- 4 years ago
Try creating a measure to use as a filter for the visual. You will need an independent table for the slicer selection
Let the independent table values be DSlicer[Value], the fact table be FactTable and the selection column be FactTable[Selection])
Filter measure = SWITCH ( SELECTEDVALUE ( DSlicer[Value] ), "Secure API", COUNTROWS ( CALCULATETABLE ( FactTable, FactTable[Selection] IN { "Devops", "CD" } ) ), "Secure Code", COUNTROWS ( CALCULATETABLE ( FactTable, FactTable[Selection] IN { "Devops", "CD", "Classic" } ) ), "Secure Infrastructure", COUNTROWS ( CALCULATETABLE ( FactTable, FactTable[Selection] IN { "Classic" } ) ) )Select the visual and add this measure as a filter, setting the value to greater or equal to 1
- 4 years ago
Just wanted to say thank you for the above and this seems to have resolved my issue 😀
No idea how you guys do it and have all this knowledge, but the above solution with the measure helped achieve what I wanted, so a big thank you from me!!
Try creating a measure to use as a filter for the visual. You will need an independent table for the slicer selection
Let the independent table values be DSlicer[Value], the fact table be FactTable and the selection column be FactTable[Selection])
Filter measure =
SWITCH (
SELECTEDVALUE ( DSlicer[Value] ),
"Secure API",
COUNTROWS (
CALCULATETABLE ( FactTable, FactTable[Selection] IN { "Devops", "CD" } )
),
"Secure Code",
COUNTROWS (
CALCULATETABLE (
FactTable,
FactTable[Selection] IN { "Devops", "CD", "Classic" }
)
),
"Secure Infrastructure",
COUNTROWS (
CALCULATETABLE ( FactTable, FactTable[Selection] IN { "Classic" } )
)
)
Select the visual and add this measure as a filter, setting the value to greater or equal to 1
Just wanted to say thank you for the above and this seems to have resolved my issue 😀
No idea how you guys do it and have all this knowledge, but the above solution with the measure helped achieve what I wanted, so a big thank you from me!!