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
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
Thank you so much. The way that you solve was easy and I got replay in my data source