Need help on DAX

[SarathB2]

Hello Experts,

I have a table and having one calculated column with Pass/Fail.

I want output like if all pass for one category then consider as pass and even one fail occur for that category then consider as fail.

something like

	Material	Insp	Check		Output
	A	OD	TRUE		TRUE
	A	DIST	TRUE		TRUE
	A	ROUND	TRUE		TRUE
	A	SFO	TRUE		TRUE
	B	OD	TRUE		FALSE
	B	DIST	FALSE		FALSE
	B	ROUND	TRUE		FALSE
	C	SFO	FALSE		FALSE
	C	OD	FALSE		FALSE
	C	DIST	FALSE		FALSE
	C	ROUND	FALSE		FALSE

Please assist,

Thanks in advance.

Regards,

Sarath.

[AlexisOlson · Accepted solution]

 Check that the Material has no false value in its group.

Output =
NOT (
    FALSE
        IN CALCULATETABLE (
            VALUES ( Materials[Check] ),
            ALLEXCEPT ( Materials, Materials[Material] )
        )
)

Slightly less intuitive but simpler:

Output =
CALCULATE (
    SELECTEDVALUE ( Materials[Check] ),
    ALLEXCEPT ( Materials, Materials[Material] )
)

[AlexisOlson · Accepted solution]

 Check that the Material has no false value in its group.

Output =
NOT (
    FALSE
        IN CALCULATETABLE (
            VALUES ( Materials[Check] ),
            ALLEXCEPT ( Materials, Materials[Material] )
        )
)

Slightly less intuitive but simpler:

Output =
CALCULATE (
    SELECTEDVALUE ( Materials[Check] ),
    ALLEXCEPT ( Materials, Materials[Material] )
)

[SarathB2]

Hi @AlexisOlson ,
In case of something like "YES" or "NO" instead of "True" or "False" , first solution is working and Second solution is not giving expected result... Right?

Thanks & Regards,

Sarath.

[AlexisOlson · Accepted solution]

Yes, the second one will return blanks when multiple values are present. These get coerced into FALSE values if the column type is a logical boolean.

To work with "Yes" / "No", I think you could just add an argument to SELECTVALUE for what to return instead of blank when there are multiple values. That is, SELECTEDVALUE ( Materials[Check], "No" ).

[SarathB2]

Okay , Super thanks for your response @AlexisOlson . 

[SarathB2]

Thanks a lot @AlexisOlson . Great solution.It's working, I will check it in my real scenorio.
Greatful for quick response.