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.

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