Exclude certain customers in my YTD measure

[Anonymous]

Hello Community  -  We have a need to exclude some of our intra-company revenue  from our YTD number.   These customer are identified by a CustomerID in the master customer table.    My current YTD measure is below, and works perfectly fine.  

But how do I get it to exclude these customers?   Essentially, I just need to filter them out.    Of course I can do this using the filters in the fitlers area, but I need it to be embedded in the measure itself.   

[v-kelly-msft]

Hi @Anonymous ，

Can you show me part of your data if it is not confidential?

Best Regards,
Kelly

[edhans · Accepted solution]

Hard to know for sure since you didn't provide any data or a visual of your model, but if I had done the model, I would be able to add another filter to my CALCULATETABLE() that would be:

Customer[CustomerType] <> "InterCompany"

If that doesn't help, please post back with more info.

[Anonymous]

The two answers provided me with an idea on how to solve this so both were helpful!

Thank you!

[edhans]

Great! Glad your project is moving forward.