Forum Discussion
Solved
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 a...
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
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 🙏