Forum Discussion

hmeltonPSL's avatar
hmeltonPSL
Icon for Helper II rankHelper II
1 year ago
Solved

Don't include blanks in COUNTROWS

I am trying to get the number of workorders with a Weekoffset =0  (this is the current week)  with the below measure.  I am getting that data but I am also getting all the rows where the weekoffset ...
  • pbiuseruk's avatar
    pbiuseruk
    1 year ago

    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.

Irwan's avatar
Irwan
Icon for Super User rankSuper User
1 year ago

hello hmeltonPSL 

 

i am not sure how you dataset looks like but do you think you can add another measure for removing blank from your countrow measure.

something like below.

COUNTX(
    FILTER(
        'workorders',
        not ISBLANK('DatesTable'[Weekoffset])
    ),
    [WOCompCurrentWeek]
)
 
Otherwise please share your sample dataset and expected outcome.
 
Hope this will help.
Thank you.
  • hmeltonPSL's avatar
    hmeltonPSL
    Icon for Helper II rankHelper II
    1 year ago

    Okay...I tried that but get an error on the measure.

     

    A single value for column 'weekoffset' in table 'DatesTable' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single......