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 on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors