Forum Discussion
Solved
Filtering a column for a slicer
I have two tables that look like this: Table 1 | Table 1 Table 2 | Table 2 Names IDs 1-->* IDs | Unique transactions The 'Names'...
Okay ^^ it was very simple and I figured it out.
=if(count(TransactionID)>0,1,0))
Then set that as a filter on the slicer with 'Names'. Only show values where the measure = 1.
Thanks you!
Care to be more specific?
I tried "Transaction ID" IS NOT BLANK but that didn't work. I assume I have to create a new table with only names with transactions, but I'm unsure how to go about doing that.
Okay ^^ it was very simple and I figured it out.
=if(count(TransactionID)>0,1,0))
Then set that as a filter on the slicer with 'Names'. Only show values where the measure = 1.
Thanks you!