Mark the rows in a table as invalid based on condition ( Dax (Cal column) or M)

[vinaydavid]

Hi experts,

I am trying to mark all the rows that that are invalid.

Please help me with Dax or M as I fairly new.

Col A	Col B	Mark
WWW	Don't Consider	X
WWW	Consider	X
WWW	Consider	X
ABC	Don't Consider	X
ABC	Consider	X
XYZ	Consider	OK

If in col B, if I find any value as "Don't Consider", then I should be able to ignore the whole bunch of rows with that ID.

So the result should be as column 'Mark'.

Thanks in advance!

[VasTg · Accepted solution]

@vinaydavid 

Try this..

Mark =
IF (
    CALCULATE (
        MAX ( 'Table (3)'[Col B] ),
        FILTER (
            ALLEXCEPT ( 'Table (3)', 'Table (3)'[Col A] ),
            'Table (3)'[Col B] = "Don't Consider"
        )
    ) = "Don't Consider",
    "X",
    "OK"
)

Change the column and table names accordingly.

If this helps, mark it as a solution.

Kudos are good too.

[Anonymous]

can I do the same condition but make in a table without add X and OK only filter the table result as a table?

[vinaydavid]

Thanks a lot for the quick response VasTg.

The DAX worked in the way I want. But as I was looking at the records, I might need to add more condition in the future.

But for now, it serves my purpose.

Appreciated!! And keep up the good work 🙂