cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tito
Frequent Visitor

Not exists in DAX

Hi community 

 

I have the following problem in which I need help please

 

I have the following data table

Capture 1.PNG

 

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

Capture2.PNG

 

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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)

            )

 

 

Filter.PNG

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

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)

            )

 

 

Filter.PNG

View solution in original post

tito
Frequent Visitor

Tank you very much, the solution is great.

Anonymous
Not applicable

Mark it as solution If it resolve your problem

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors