The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.
User | Count |
---|---|
15 | |
13 | |
9 | |
6 | |
6 |
User | Count |
---|---|
28 | |
18 | |
13 | |
9 | |
5 |