Neri Kim
Neri Kim

Reputation: 171

How to remove blank data in column chart in PowerBI

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?

enter image description here

Thank you!

Upvotes: 1

Views: 584

Answers (1)

davidebacci
davidebacci

Reputation: 30324

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).

Upvotes: 1

Related Questions