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 (blu...
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.

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.