Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi all,
I have columns 'ID' and 'PO'
PO columns has values 0, 100 and blank cells.
I want the count of ID where PO = 0 (only). But even the blank gets counted.
I have used this dax to eliminate blank but still I dont get the output desired. I get blank value instead .
Please help.
Hi: You can try this measure:
Hi,
In the Query Editor, change the data type of the PO column to Text. Now try this measure
SKUswith0 = CALCULATE(DISTINCTCOUNT('Master Data'[id]),'Master Data'[PO] = "0")
If you do not want to change the data type, then try this measure
SKUswith0 = CALCULATE(DISTINCTCOUNT('Master Data'[id]),'Master Data'[PO] == 0)
Hope this helps.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 10 | |
| 10 | |
| 8 | |
| 6 | |
| 6 |
| User | Count |
|---|---|
| 24 | |
| 18 | |
| 16 | |
| 15 | |
| 9 |