Forum Discussion

ajdm2007's avatar
ajdm2007
Icon for Helper III rankHelper III
1 year ago

Guys,

I think the problem is not in the relationship, I have tried this formula and it didn't work either:

tmp = 
CALCULATE(
    COUNTROWS(
        FILTER(
            tickets,
            tickets[status]=">Completed*" && tickets[status]=">Completed (No email)"
        )
    ),
    PREVIOUSMONTH('calendar'[date])
)

 

Unless the issue is in the relationship of the calendar table.

 

Any idea?

 

Thank you so much.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

Contrary to natural language, " I want a and b" is expressed in boolean logic via OR  (||), not AND (&&)

 

 

tmp = 
CALCULATE(
    COUNTROWS(tickets)
    tickets[status] IN {">Completed*",">Completed (No email)"},
    PREVIOUSMONTH('calendar'[date])
)