Forum Discussion

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

Aplying conditional filters in table

Hi community, 

 

I have this table I created  Power Bi desktop, which already contains some filters such as stage (Stage 1 or Stage 2 or Stage 3), Status (Active and Declined):

 

but I don't know how to apply additional filters to validate: If status="Declined" then take the "Declined Date" from the current month to get this

 

 

It seems the alternative is to create a new Calculated table but I don't have that option. Are there any other ways to do it? 

 

Thank you!

 

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi mcantos ,

    I created a sample pbix file(see the attachment), please check if that is what you want.

    1. Create a measure as below

    Flag = 
VAR _product =
    SELECTEDVALUE ( 'Table'[Product] )
VAR _tab =
    CALCULATETABLE (
        VALUES ( 'Table'[Product] ),
        FILTER (
            'Table',
            'Table'[Status] = "Active"
                || (
                    'Table'[Status] = "Declined"
                        && YEAR ( 'Table'[Declined Date] ) = YEAR ( TODAY () )
                )
        )
    )
RETURN
    IF ( _product IN _tab, 1, 0 )

    2. Create a table visual and apply a visual-level filter with the condition (Flag is 1)

    Best Regards

4 Replies

  • Uzi2019's avatar
    Uzi2019
    Icon for Community Champion rankCommunity Champion
    1 year ago

    Hi mcantos 

     

    Try this calculated column

    New Date =
    var A= DATE(YEAR(TODAY()),MONTH(TODAY()),DAY('Product Status'[Declined Date]))
    var b= IF('Product Status'[Status]="Declined",A,BLANK())
    RETURN b
     
    and check the screenshot below.

     

    In the screenshot all the status which value are decline have replaced their month and year value by keeping the Day value.

     

     

    I hope I answered your question!

     

    • mcantos's avatar
      mcantos
      Icon for Helper II rankHelper II
      1 year ago

      Thank you Uzi2019  for your replay but I don't want to change the dates and sorry because I think I was not clear enough

       I want to keep the dates and apply a new filter that allows me to keep the products with "Active" status and products with "Declined" status and the declined date is in the current month. So, in the end, after applying the filters I must have as result these two rows: 

      Thank you again

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi mcantos ,

        I created a sample pbix file(see the attachment), please check if that is what you want.

        1. Create a measure as below

        Flag = 
VAR _product =
    SELECTEDVALUE ( 'Table'[Product] )
VAR _tab =
    CALCULATETABLE (
        VALUES ( 'Table'[Product] ),
        FILTER (
            'Table',
            'Table'[Status] = "Active"
                || (
                    'Table'[Status] = "Declined"
                        && YEAR ( 'Table'[Declined Date] ) = YEAR ( TODAY () )
                )
        )
    )
RETURN
    IF ( _product IN _tab, 1, 0 )

        2. Create a table visual and apply a visual-level filter with the condition (Flag is 1)

        Best Regards

  • mcantos's avatar
    mcantos
    Icon for Helper II rankHelper II
    1 year ago

    Thank you so much Anonymous ,

    That's exactly what I needed.