Forum Discussion

BayliCapri's avatar
BayliCapri
Regular Visitor
1 year ago
Solved

Boolean Measure as a Slicer

Hello! I am trying to create a slicer with a simple boolean measure I've made but it doesn't work when I try to drag and drop. The DAX is as follows:

 

Name Match = IF(MIN('Query1'[Apollo Company Name]) <> MIN('Query1'[Company Name]), "Not Matching" , "Matching")
 
There would only be two options for the slicer. This is to filter by company names matching between two data gathering programs. How would I go about turning this into a useable slicer?