Not exists in DAX

[Anonymous]

Hi community 

I have the following problem in which I need help please

I have the following data table

I need to create a metric in dax that will return the sum of the items that are on stage 0 and are not on stage 1

In sql the query is as follows

SELECT * FROM

ESCENARIOS A

WHERE A.ESCENARIO=0 AND
NOT EXISTS (SELECT * FROM ESCENARIOS WHERE A.CODIGO=CODIGO AND RUBRO=A.RUBRO AND A.MES=MES AND ESCENARIO=1)

Thanks

[Anonymous · Accepted solution]

Add below column in visual level filter and set filter=True.

Filter = ESCENARIOS[ESCENARIO]=0 &&

    ISEMPTY(

        FILTER(ESCENARIOS,ESCENARIOS[CODIGO]=EARLIER(ESCENARIOS[CODIGO]) && ESCENARIOS[RUBRO]=EARLIER(ESCENARIOS[RUBRO])

                && ESCENARIOS[MES]=EARLIER(ESCENARIOS[MES]) && ESCENARIOS[ESCENARIO]=1)

            )

[Anonymous]

Tank you very much, the solution is great.

[Anonymous]

Mark it as solution If it resolve your problem