Filter values based on static value

[Dayna]

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 list of component values, and I want to return the ones where a specific column equals a static value. On the below example, I'd like to bring back all ps_comp records where the field "sub_assembly_inc_lotion" equals "Yes".

Can someone advise, please?

Parent	ps_comp	sub_assembly_inc_lotion
LQ20303X03	9041	No
LQ20303X03	9045	No
LQ20303X03	9046	No
LQ20303X03	9048	No
LQ20303X03	LQ20303X03_F08	Yes
LQ20303X03	LQ20303X03_G01	Yes
LQ20303X03	LQ20303X03_G03	Yes

[Dayna]

My original use case was to use the value within the table alongside with other records, so I wasn't convinced that a visual filter would work... I'll see if I can change my approach a little, and perhaps link the charts to bookmarks to show different filtered views of the data based on the bookmark selected.

Thanks for the responses all, very much appreciate this forum!

[Anonymous]

Hi @Dayna ,

Did you get a proper approach for your problem? If yes, could you please share it with us if it is convenient? Thank you.

Best Regards

[Dayna · Accepted solution]

I refactored my tables and relationships to achieve it on a data level rather than within PowerBI. 

[luohen]

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

[lbendlin]

A standard visual level filter should do that for you. Have you tried that?