Forum Discussion
Solved
Filter values based on static value
Hello, I suspect this is a fairly easy one, but I'm struggling to work out whether the measure should be a CALCULATE(), SUMMARIZETABLE() or something else...! Basically, I have a table with a...
I refactored my tables and relationships to achieve it on a data level rather than within PowerBI.
Hi Dayna ,
If you still want the records where the field "sub_assembly_inc_lotion" equals "No" exist in the source query, you can follow the suggestion from to create a table visual and apply a visual-level filter with the condition (sub_assembly_inc_lotion is "Yes") on the table visual just as below screenshot.
And if you just want to keep the records where the field "sub_assembly_inc_lotion" equals "Yes" in Query Editor by using Filter function, you can handle with it in Power Query Editor.
Best Regards