Forum Discussion

aameen1515's avatar
aameen1515
Helper I
6 years ago
Solved

Weekly In Progress & filters

Hi All   I need to plot the “In Progress” reqs info in a bar chart by week. My source table has following info.   Non RFx1 is the table name req recvd dt NR Executed Date NR NR Reques...
Need Help
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    6 years ago

    Hi aameen1515 ,

     

    We can create a measure and name slicer to meet your requirement.

     

    1. Create a date table that has no relationship with Non RFx1 table.

     

     

     

    2. Then we can create a measure based on your original calculate column.

     

    Non RFx1 InProgress = 
CALCULATE (
    COUNTROWS ( 'Non RFx1' ),
    FILTER (
        'Non RFx1',
        ( 'Non RFx1'[req recvd dt NR] ) <= MAX('Calendar table'[Date])
            && ( 'Non RFx1'[Executed Date NR] ) >= MAX('Calendar table'[Date])
    )
)
    + CALCULATE (
        COUNTROWS ( 'Non RFx1' ),
        FILTER (
            'Non RFx1',
            ( 'Non RFx1'[req recvd dt NR] ) <= MAX('Calendar table'[Date])
                && ( 'Non RFx1'[NR Request Status] = "In Progress" )
        )
    )

     

    3. Create a slicer using BuyerName and put the BuyerName to Filters on this page, then configure the BuyerName is not blank.

     

     

     

    If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

    BTW, pbix as attached.

     

    Best regards,

     

    Community Support Team _ zhenbw

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

v-zhenbw-msft's avatar
v-zhenbw-msft
Community Support
6 years ago

Hi aameen1515 ,

 

We can create a measure and name slicer to meet your requirement.

 

1. Create a date table that has no relationship with Non RFx1 table.

 

 

 

2. Then we can create a measure based on your original calculate column.

 

Non RFx1 InProgress = 
CALCULATE (
    COUNTROWS ( 'Non RFx1' ),
    FILTER (
        'Non RFx1',
        ( 'Non RFx1'[req recvd dt NR] ) <= MAX('Calendar table'[Date])
            && ( 'Non RFx1'[Executed Date NR] ) >= MAX('Calendar table'[Date])
    )
)
    + CALCULATE (
        COUNTROWS ( 'Non RFx1' ),
        FILTER (
            'Non RFx1',
            ( 'Non RFx1'[req recvd dt NR] ) <= MAX('Calendar table'[Date])
                && ( 'Non RFx1'[NR Request Status] = "In Progress" )
        )
    )

 

3. Create a slicer using BuyerName and put the BuyerName to Filters on this page, then configure the BuyerName is not blank.

 

 

 

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

BTW, pbix as attached.

 

Best regards,

 

Community Support Team _ zhenbw

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

aameen1515's avatar
aameen1515
Helper I
6 years ago

Hi v-zhenbw-msft v-zhenbw-msft

 

Can you help resolve my latest query? Really appreciate it!

 

Cheers!

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Community Support
    6 years ago

    Hi aameen1515 ,

     

    This seems to be a new topic.

    We suggest that you restart a new thread.

    Because the two content under the same title will make it difficult for other users to find the corresponding issue. 

    If you start a new thread and describe your issue clearly, more people will find your issue and provide you with a better answer.

     

    Best regards,

     

    Community Support Team _ zhenbw

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