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
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)
Go to Solution.
Add below column in visual level filter and set filter=True.
Filter = ESCENARIOS[ESCENARIO]=0 &&
FILTER(ESCENARIOS,ESCENARIOS[CODIGO]=EARLIER(ESCENARIOS[CODIGO]) && ESCENARIOS[RUBRO]=EARLIER(ESCENARIOS[RUBRO])
&& ESCENARIOS[MES]=EARLIER(ESCENARIOS[MES]) && ESCENARIOS[ESCENARIO]=1)
View solution in original post
Tank you very much, the solution is great.
Mark it as solution If it resolve your problem
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.