Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi Folks,
I've already done some research but am still having trouble on this. My objective is to display COUNT of 0s on a card from a specific column. Included some pics below.
Thank you,
PBInJelly
@PBInJelly Should just be a measure like:
Measure = COUNTROWS(FILTER('Table',[Days from] = 0))
And it is giving me a total of 540 when it should be 3 on the card. Any idea why?
@PBInJelly Hard to say without sample/source data. Are you truly trying to find 0's in a column in a table or is your zero count based upon a measure in a table visual?
@Greg_Deckler The column is an existing measure that simply subtracts from a local date. I'm trying to get the number of single "0"s from either the table/column in power query or the visual table's column.
@PBInJelly Well if it is the latter, construct the table visualization as a table VAR in DAX using ADDCOLUMNS, etc. Then you can COUNTROWS(FILTER()) across it or use things like COUNTX.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 5 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 16 | |
| 8 | |
| 7 | |
| 7 |