BOOLEAN column based on numerous filters

[joshua1990]

Hey community!

I have a table like this:

Order	Date	Department	Area	State	Value	Quantity	Cost	Employee
100	01.01.2020	Metallurgy	Area 1	50	999	9562	8950	Alex

Now I need a Dax Measure (not a column) that shows me TRUE or FALSE based on this heuristic:

TRUE IF

• State >= 0 <= 50
• State <> 51
• State <= 95
• Department <> "Metallurgy"
• Area <> "Area 1"

How would you build that Measure?

[AlB]

Hi @joshua1990 

You want a measure but are referring to row context (the values in a row of the table) to define the outcome. That seems contradictory. Can you elaborate?  The measure would have to check all rows in the table? If so, how would the final result be constructed from all those checks? Or are you going to use the measure in a table visual such that the measure will be applied to each row depicted in the visual?

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers