Filter view to remove rows that have multiple blank fields

[BigBenBeaubien]

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.

[Anonymous · Accepted solution]

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]

Thanks @Anonymous this is exactly what i needed !

[BigBenBeaubien]

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.

[NimaiAhluwalia]

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