Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Not exists in DAX

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
6 years ago
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)
            )

3 Replies

Anonymous
Not applicable
6 years ago
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
  Not applicable
  6 years ago
  Mark it as solution If it resolve your problem
- Anonymous
  Not applicable
  6 years ago
  Tank you very much, the solution is great.

Related content