Forum Discussion
DAX
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.
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
4 Replies
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 __ResultThank you so much. The way that you solve was easy and I got replay in my data source
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 )You understood correctly. Thank you so much for help me 🙏
