filter only one column in power bi

[Syndicate_Admin]

Good afternoon I would like to know how I can only filter a column in power bi

I would like the payment status to only affect the PAID/SENT FOR PAYMENT column.

Thank you very much in advance.

[littlemojopuppy · Accepted solution]

@Syndicate_Admin I assume you mean filter only the indicated column with a slicer?  If so, create a measure for the others that are essentially CALCULATE([Current Measure Definition], REMOVEFILTERS([Whatever The Slicer Filters On]).  Obviously not syntactically correct, but should get you close.

If you're talking about cross filtering from other visuals, that's more complicated and we can discuss...

Let me know how it works!