How to remove blank data in column chart in PowerBI

Question

I have used the following dax formula to count rows based on dates filtering out blank ("null") data:

Avsluttet = CALCULATE(COUNTROWS(TICKET),NOT(ISBLANK('Table'[closed_at])), USERELATIONSHIP(Dato[Opprettet dato], TICKET[closed_at]))

In the visualization one column is appearing blank, why is that when I have excluded blank data in the measure?

Thank you!

Answer 1

Try this instead:

Avsluttet = CALCULATE(COUNTROWS(TICKET),'Table'[closed_at] <> BLANK(), USERELATIONSHIP(Dato[Opprettet dato], TICKET[closed_at]))

You can read why here: https://dax.guide/isblank/

Empty strings are not considered blank by ISBLANK() (strict equality is used).