Reputation: 171
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!
Upvotes: 1
Views: 584
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