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.
Resolver IVHello,
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.
Helper IISo I actually changed by view for the dataset to include only completed workorders and changed the Measure to below and it is now working as expected. Thanks!
WorkordersCompCurrentWeek = COUNTROWS (
CALCULATETABLE (
'completedworkordersonly',
FILTER (
'completedworkordersonly',
'completedWorkordersonly'[DivisionType] = "HelpDesk"
),
FILTER (
'DatesTable',
('DatesTable'[Weekoffset] = 0)
)
)
)