Forum Discussion
Filter view to remove rows that have multiple blank fields
- Anonymous1 year ago
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 XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
Thanks Anonymous this is exactly what i needed !