Where statement in "IN FILTERS"

[Anonymous]

hello i have an inactive relationship between revenue and salesman and i want to calculate the revnue that salesman client made : i got to this formula:

 CALCULATE(SUM( Revenues[Amount]),FILTER(Revenues,Revenues[Platform]="A"),FILTER (
ALLSELECTED ( Revenues ),
        Revenues[Client Name]
            IN FILTERS( (Salesman[Client Name] ))

my problem is its taking all names that have same client name from platform A and B where i only want the clients from saleman of platform "A".so i want to add a where clause so i have something like:
in filters( (salesman[client name] where platform = "A" )) 

[v-yadongf-msft]

Hi @Anonymous ,

Can you share with me some screenshots of your data after hiding sensitive information?

Thanks for your efforts & time in advance.

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.