Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
I am using this dax formular here but when there is a blank / null the card visual shows "Blank" i have tried every trick and i cant get rid of the blank. anyone know how to get rid of it?
hi @Anonymous
I usually add variable is check if it is blank:
Count =
VAR tmp = COALESCE(CALCULATE(DISTINCTCOUNT('WORKORDER'[SYSTEM])),0)
still getting a blank.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
102 | |
68 | |
45 | |
37 | |
36 |