Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am attempting to count my orders in process. I am using the below CALCULATE formula. When I manually go to the Facts table and filter the columns as outlined below, I get an entirely different row count than what this formula is returning. Does anyone know why?
Manual Filters applied: Status ID =3 AND CloseOutDate = BLANK (returns 42 rows)
Below formula returns 9 rows in my visual.
InProcessCnt = CALCULATE(COUNTROWS(Facts), FILTER(Facts, Facts[status_id] = 3 && Facts[CloseOutDate] = BLANK()) )
I am a novice, mostly self taught, and an ops person - so the simpler the better please!
Also in the meantime you can try
InProcessCnt = CALCULATE( COUNTROWS(Facts), Facts[status_id] = 3, Facts[CloseOutDate] = BLANK() )
(the FILTER is extraneous when using CALCULATE and not filtering on MIN/MAX etc)
David
Hi @TPearson - how are you displaying InProcessCnt ? Sounds like there might be other filters in play. Can you share copy of your pbix with sensitive data removed (link from OneDrive, DropBox, Github, Google Drive, etc)
David
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
7 |