Forum Discussion

BigBenBeaubien's avatar
BigBenBeaubien
Regular Visitor
1 year ago
Solved

Filter view to remove rows that have multiple blank fields

Hi guys, 
i've been trying but cant figure this out.
I want to remove rows that dont have any (AD_GroupName) AND (SM_Serial_No) so basically the bottom (red sqare)
I want to keep the top part (blue sqare)
Is this doable by filter view ??
Please let me know if you can help me.

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi BigBenBeaubien 

     

    Thanks for the reply from NimaiAhluwalia .

     

    BigBenBeaubien , if I understand correctly, when the AD_GroupName column and SM_Serial_No column are empty, the row does not need to be displayed, please refer to the following test.

     

    Sample:

     

    Create a measure as follows

    Measure = IF(MAX('Table'[AD_GroupName]) = BLANK() && MAX('Table'[SM_SERIAL_NO]) = BLANK(), 0, 1)

     

    Put the measure into the visual-level filters, set up show items when the value is 1.

     

    Output:

     

    Best Regards,
    Yulia Xu

     

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

4 Replies

  • NimaiAhluwalia's avatar
    NimaiAhluwalia
    Continued Contributor
    1 year ago

    hello BigBenBeaubien 

     

    yes it is possible you can filter out the values of the column with multiple logics in the filter pane for that you have to select the visual and click the filter pane to open and than under that column you have to set the logic for example in your case that AD_GroupName should not contain blank or is not blank.

     

    If this solves your concern please accept it as a solution.

    Thanks

  • BigBenBeaubien's avatar
    BigBenBeaubien
    Regular Visitor
    1 year ago

    Hello NimaiAhluwalia 
    Thanks for you quick response. Unfortunatly this is not the solution for my problem.
    no matter what i do , this doesnt seem to be possible.
    if i do like you said and use the AD_GroupName filter, i lose rows that have data in SM_Serial_No (rows 11 to 17)
    keep in mind that some rows have data in AD_GroupName and some rows have data in SM_Serial_No.
    When both of these are empty , i want to not show them.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi BigBenBeaubien 

     

    Thanks for the reply from NimaiAhluwalia .

     

    BigBenBeaubien , if I understand correctly, when the AD_GroupName column and SM_Serial_No column are empty, the row does not need to be displayed, please refer to the following test.

     

    Sample:

     

    Create a measure as follows

    Measure = IF(MAX('Table'[AD_GroupName]) = BLANK() && MAX('Table'[SM_SERIAL_NO]) = BLANK(), 0, 1)

     

    Put the measure into the visual-level filters, set up show items when the value is 1.

     

    Output:

     

    Best Regards,
    Yulia Xu

     

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