Adding an additional FILTER to my measure

[Alicia83B]

Below is my current measure for Distributor Activity Count. I would like to add three specific Manufacturers to show Distributor Activity Count for in this measure. I have been looking for something similar to help me with this, but have not found anything. 

Manufactuters would be 1, 2, 3

Dist Activity Count =
COUNTX (
    FILTER (
        Activity,
        Activity[activitytype]
            IN ( {
            "Distributor Business Review",
            "Distributor Sales Call",
            "Distributor Business Planning",
            "DSR Training",
            "Opportunity Follow Up",
            "Pricing / Order Management",
            "Quote Opportunity / Cross Reference",
            "Sales Meeting",
            "Send Samples / Literature",
            "Trade Show / Open House",
            "Work with DSR"
        } )
    ),
    Activity[ActivityIDKey]
)

Any help is much appreciated. 

Thank you.

[Anonymous]

Hi @Alicia83B ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_ Binbin Yu

[Alicia83B]

Good morning @Anonymous 

Below is a snapshot of the KPI data and result I am looking for. I already have the measure for the Activity Types as listed in my original post. The KPI is have the Activity Types I have captured in the measure only show in the gauge visualization if the Manufacturers are AI, SS, and FB. When I tried the solution provided it does not work. I am trying to see if I can add a Manufacturer to my measure already created, or if I should create another measure referencing the original measure capturing the Activity Types.

I hope I have explained this well. I am still getting familiar with PBI and how to express exactly what I am looking for in terms that are understandable. Thank you.

Start Date	End Date	KPI Name	KPI Description	Goal	KPI Type	Manufacturer	Activity Types
9/1/2022	12/31/2022	National Focus	AI, SS, and FB  EU / Distributor Activities	30	EU/ Dist Activities	AI, SS, FB	Distributor Business Meeting, Distributor Sales Call, Distributor Business Planning, End User Sales Call, End User Business Retention, End User Training, DSR Training, Opportunity Follow Up, Pricing / Order Management, Quote Opportunity / Cross Reference, Sales Meeting, Send Sample / Literature, Trade Show / Open House, Work with DSR

[PabloDeheza]

Hi there!

To add filters on a FILTER statement you can use &&. So in your code you can add a new filter using && after closing the IN bracket.

Dist Activity Count =
COUNTX (
    FILTER (
        Activity,
        Activity[activitytype]
            IN ( {
            "Distributor Business Review",
            "Distributor Sales Call",
            "Distributor Business Planning",
            "DSR Training",
            "Opportunity Follow Up",
            "Pricing / Order Management",
            "Quote Opportunity / Cross Reference",
            "Sales Meeting",
            "Send Samples / Literature",
            "Trade Show / Open House",
            "Work with DSR"
        } )

&& Manufacturer IN { 1, 2, 3 }

    ),
    Activity[ActivityIDKey]
)

Let me know if that helps!

[Alicia83B]

@PabloDeheza  This did not work for me. When I add the && Manufacturer, Manufacturer is not showing in the list for me to select. Manuafcturer is only showing the fields in Activity table. Is there anther way I can write this that will allow the Manufaacturer table to show in the list for me to set the field I wantt to bring into the measure?