How can I count In progress

[Anonymous]

Hello great people:

As you can see my naive question. New in Power BI so still processing few options. Could you please help me to understand the calculation process:

In progress Count Measure  = Overall Status = Complete, in prgogress, (Blanks) AND PWC Actaul Completion Date Filter out blank. AND PWC Schedule Completion Date filter out before Today

Notw:

Table 1

Coloumn:

Overall Status

PWC Actaul Completion Date

PWC Schedule Completion Date

Appreciate your help.

Thanks

[Anonymous]

Appreciatae your help and support. Thanks.

[v-kkf-msft · Accepted solution]

Hi @Anonymous ,

I am not sure if I understood your question correctly. Is this your desired output?

Measure = 
COUNTROWS (
    FILTER (
        'Table',
        'Table'[Overall Status]
            IN { "Complete", "in progress", BLANK () }
                && 'Table'[PWC Actaul Completion Date] = BLANK ()
                && 'Table'[PWC Schedule Completion Date] <= TODAY ()
    )
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I want something like below: 

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()

[TomMartens]

Hey @Anonymous 

I have to admit that I do not understand your question. Maybe you are trying to solve an event-in-progress problem, than this article Events-In-Progress for Time Periods in DAX – Gerhard Brueckl on BI & Data (gbrueckl.at) contains all the links one has to know, and of course provides a solution for a special requirement. Start reading the article form Jason Thomas.

If this is not what you are looking for, consider creating a pbix that contains sample data but still reflects your data model (tables, relationships, calculated columns, and measures). Upload the pbix to onedrive or dropbox and share the link. If you are using Excel as a data source instead of using the manual input method, share the xlsx as well.

Describe the expected result based on the sample data you provided.

Regards,

Tom