I simply want to count rows consisting number "1" and "2" in a column, I used the following measure:
First time fix = CALCULATE(COUNTROWS(TICKET), TICKET[num_replies]=1 && TICKET[num_replies]=2 , USERELATIONSHIP(DIM_DATO[Opprettet], TICKET[Created]))
But it returns blank, how should I change the syntax in order to return a number?
>Solution :
Use OR in place of AND
First time fix = CALCULATE(COUNTROWS(TICKET), TICKET[num_replies]=1 || TICKET[num_replies]=2 , USERELATIONSHIP(DIM_DATO[Opprettet], TICKET[Created]))