topic Calculate today cases in DAX Commands and Tips

Calculate today cases

Michael92 — Tue, 12 Jul 2022 09:54:58 GMT

Hello all,

I would like to count the number of cases for today and if there is an empty value, write zero.

I have already created these measures, but how to connect them together and create one measure?

Count_today = CALCULATE (DISTINCTCOUNT ( 'case'[id_case] ), 'case'[date] = TODAY ())

Count_zero_value = if(isblank(DISTINCTCOUNT(case[id_case])),0,DISTINCTCOUNT(case[id_case]))

Thank you

Michael

Re: Calculate today cases

Migasuke — Tue, 12 Jul 2022 10:04:34 GMT

Hi Michael92 ,

I don't think you need the second measure if I understand correctly.

Try following:

MyMeasure =
var Count_today = CALCULATE (DISTINCTCOUNT ( 'case'[id_case] ), 'case'[date] = TODAY ())

return
IF(
ISBLANK(Count_today,0,Count_today)
)

Re: Calculate today cases

Michael92 — Tue, 12 Jul 2022 11:22:31 GMT

The syntax for 'returnif' is incorrect 🙄

Too many arguments were passed to the ISBLANK function. The maximum argument count for the function is 1.

Re: Calculate today cases

Michael92 — Tue, 12 Jul 2022 11:40:23 GMT

OK, now it works. Only a few parentheses needed to be added.

MyMeasure =
var Count_today = CALCULATE (DISTINCTCOUNT ( 'case'[id_case] ), 'case'[date] = TODAY ())

return
IF(
ISBLANK(Count_today),0,(Count_today)
)

Thank you 😊