Forum Discussion
Helper IIDon't include blanks in COUNTROWS
Hello,
Couple notes. If you're using the filter function for the same table, then you can use && or || for multiple conditions.
Why don't you also say in your condition that complete date can't equal blank (just to test if that works)?
Also, I usually make an additional column for my week offset columns which is of a string type and I have a formula in there which says to rename the 0 to "Current Week". I do this because in the line charts or column charts it comes through quite nicely. Also, for all of the other prior weeks I call it Week -X.
Hi [User],
Thanks for reaching out to the Microsoft fabric community forum.
You're right the issue is that rows with blank DateComplete values cause Weekoffset to be blank, and those are being included in your count unless explicitly filtered out in the measure.
While using visual-level filters can hide those blanks, DAX measures require that condition to be written directly.
Here's the recommended fix:
WOCompCurrentWeek =
CALCULATE (
COUNTROWS ( 'workorders' ),
'workorders'[statusid] = 3,
'workorders'[DivisionType] = "HelpDesk",
NOT ISBLANK ( 'DatesTable'[Weekoffset] ),
'DatesTable'[Weekoffset] = 0
)
This ensures only work orders from the current week are counted, and blanks are excluded.
Thanks to pbiuseruk and Irwan for the suggestions especially around filtering logic and data modeling practices.
I hope this will resolve your issue, if you need any further assistance, feel free to reach out.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thankyou.
Helper IIThanks but I have tried this and I am still getting the wrong numbers. The corect number is always one less than the measure...which I am guessing is the Blanks count.