DAX Count to Show 0 instead ob Blanks by Status

RobertoArreola8 — Fri, 08 Sep 2023 18:44:26 GMT

hello everyone.

I am asking for your help, since this topic is driving me crazy. I've been trying to do a DAX based on a basic count, which is pretty simple. What I'm looking to do is to have the result of that DAX shows the blank fields as "0", but I haven't been able to find a good solution.

The formula I am using is the following:

StatusCountByCustomer =
SUMX(
VALUES('Retail Calendar'[Partner Name]),
CALCULATE(
DISTINCTCOUNT('Retail Calendar'[Status])
)
)

The options I have used to display the "0" are the following:

StatusCountByCustomer3 =
VAR StatusCountByCustomer = SUMX(
VALUES('Retail Calendar'[Partner Name]),
CALCULATE(
DISTINCTCOUNTNOBLANK('Retail Calendar'[Status])
))
RETURN
IF(
StatusCountByCustomer = BLANK(),
0,
StatusCountByCustomer
)

This is an example on where I want to show the blank results as "0"

Thank you guys in advance! Hoping you can help me.

Re: DAX Count to Show 0 instead ob Blanks by Status

some_bih — Fri, 08 Sep 2023 19:02:47 GMT

Hi RobertoArreola8

Not recommended for "big" number of rows, but you can always "add zero", like

Your measure + 0

Hope this help / kudos appreciate

topic Re: DAX Count to Show 0 instead ob Blanks by Status in DAX Commands and Tips

DAX Count to Show 0 instead ob Blanks by Status

Re: DAX Count to Show 0 instead ob Blanks by Status