Do not see any count in measure

[Anonymous]

Hello:

I have used the following Formula:

PWC Past Due = CALCULATE(COUNTROWS(Table_query__1),FILTER(Table_query__1,(Table_query__1[Overall Status]="Completed"||Table_query__1[Overall Status]="In-Progress" && BLANK())&&ISBLANK(Table_query__1[PwC Actual Complete Date])||Table_query__1[PwC Actual Complete Date]<TODAY()))

Could not see any result. 

I want to create a measur for : In progress Count  = Overall Status column = "Complete", "in progress", "(Blanks)" AND PWC Actaul Completion Date  colum Filter out only  "(Blanks)". AND PWC Schedule Completion Date filter out before Today <=TODAY()

Appreciate your help.

Thanks

[v-zhangti · Accepted solution]

Hi, @Anonymous 

I have simulated some data, you can try the following methods.

PWC Past Due = 
CALCULATE (
    COUNTROWS ( Table_query__1 ),
    FILTER (
        ALL ( Table_query__1 ),
        Table_query__1[Overall Status] = "Completed"
            || Table_query__1[Overall Status] = "In-Progress"
                && BLANK ()
                && (
                    SELECTEDVALUE ( Table_query__1[PwC Actual Complete Date] ) <> BLANK ()
                        || SELECTEDVALUE ( Table_query__1[PwC Actual Complete Date] ) < TODAY ()
                )
    )
)

Does getting this result in this data match the output you want?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Try like

PWC Past Due = CALCULATE(COUNTROWS(Table_query__1),
FILTER(Table_query__1,(Table_query__1[Overall Status] in {"Completed", "In-Progress"} || isblank(Table_query__1[Overall Status]))
&& ISBLANK(Table_query__1[PwC Actual Complete Date]) || Table_query__1[PwC Actual Complete Date]<TODAY()))