DAX

[LeonardCs]

Hi guys,

I have a table with column 'number' and column 'name'.
At column 'number' some people has '00' and '02', and some people has '00' and outhers numbers.
I need a table with the name of all people that has only number '00' and outhers numbers.
I DON'T need the people that has '00' and '02' at same time (like bold text below)

Example:

number                   name

00                          Leonardo

05                          Leonardo

00                          Eduardo

02                          Eduardo

00                          Felipe

06                          Felipe

00                          Austin

00                         Will

02                         Will

My table need has Leonardo, Felipe and Austin.

Thank all and sorry my english. I'm Brazlian.

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

Name new table =
VAR _list =
    SUMMARIZE (
        FILTER (
            ADDCOLUMNS (
                VALUES ( data[name] ),
                "@condition", CALCULATE ( COUNTROWS ( FILTER ( data, data[number] IN { "00", "02" } ) ) )
            ),
            [@condition] <> 2
        ),
        data[name]
    )
RETURN
    FILTER ( data, data[name] IN _list )

[LeonardCs]

You understood correctly. Thank you so much for help me 🙏

[Greg_Deckler · Accepted solution]

@LeonardCs You could create a Complex Selector like the following and then just filter for 1. PBIX is attached.

Flag Measure = 
    VAR __2s = COUNTROWS( FILTER( 'Table', [number] = "02" ))
    VAR __Result = IF( __2s > 0, 0, 1 )
RETURN
    __Result

[LeonardCs]

Thank you so much. The way that you solve was easy and I got replay in my data source