convert

[aservan]

Guys, I have a problem, I can't convert this select to PB's DAX, could someone help me?

>>SELECT count(*) as open_open FROM [BASE].[dbo].[Fact_Call] to where a.DateOpen <= '2022-10-31' and (a.StatusCalledID not in (4, 12) or (a.StatusCalledID in (4, 12) and a.DateClosing > '2022-10-31'))<<

[JorgePinho · Accepted solution]

Hello @aservan !

I think you want something like this:

open_open = 
CALCULATE(COUNT([insert column]), OR(a.DateOpen <= DATE(2022,10,31) && NOT(a.StatusCalledID IN {4,12}), a.StatusCalledID IN {4,12} && a.DateClosing > DATE(2022,10,31)))

[aservan]

TKS MANNNN!