Filtering Out Category

Question

Hi all,&nbsp;&nbsp;Is there a way I can use and opposite of the 'IN' function to filter a measure? I have previously used a quick measure to filter my value e.g.&nbsp;&nbsp;Sales filterd out 'B'= CALCULATE(&nbsp;&nbsp;&nbsp;&nbsp;[Sales],&nbsp;&nbsp;&nbsp;&nbsp;'Cost Account'[Category] IN {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BLANK(),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"A",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"C",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"D",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"E"})&nbsp;This does work however the list of categories will change meaning the value won't be correct if any changes to the list occur. Instead I am looking to filter out 'B' rather than keep in all other categories e.g.Sales filterd out 'B'= CALCULATE(&nbsp;&nbsp;&nbsp;&nbsp;[Sales],&nbsp;&nbsp;&nbsp;&nbsp;'Cost Account'[Category] OUT {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BLANK(),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"B"})&nbsp;How can I write this correctly?&nbsp;

anonymous · Accepted Answer

Hi&nbsp;s_mansell&nbsp;,&nbsp;&nbsp;You can write this as&nbsp;&nbsp;Sales filterd out B=CALCULATE(&nbsp;&nbsp;&nbsp;&nbsp;[Sales],NOT&nbsp;&nbsp;&nbsp;&nbsp;'Cost Account'[Category] IN {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BLANK(),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"B"})&nbsp;Regards,Harsh NathaniDid I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Forum Discussion

Filtering Out Category

2 Replies

Related content

Average of categories over vendor

Category filter

Filter

MAPE calculation with multiple categories selected in a filter

Filter only highest value by category