topic Re: DAX in DAX Commands and Tips

DAX

LeonardCs — Mon, 17 Jun 2024 15:39:11 GMT

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.

Re: DAX

Greg_Deckler — Mon, 17 Jun 2024 17:06:29 GMT

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

Re: DAX

Jihwan_Kim — Mon, 17 Jun 2024 17:08:32 GMT

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 )

Re: DAX

LeonardCs — Mon, 17 Jun 2024 17:41:13 GMT

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

Re: DAX

LeonardCs — Mon, 17 Jun 2024 17:44:17 GMT

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