Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Impactful Individual
Impactful Individual

Where statement in "IN FILTERS"

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" )) 

Community Support
Community Support

Hi @eliasayy ,

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.


Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.


Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors