BOOLEAN column based on numerous filters

joshua1990 — Tue, 20 Oct 2020 08:36:41 GMT

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?

Re: BOOLEAN column based on numerous filters

AlB — Tue, 20 Oct 2020 09:51:23 GMT

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

topic BOOLEAN column based on numerous filters in DAX Commands and Tips

BOOLEAN column based on numerous filters

Re: BOOLEAN column based on numerous filters