DAX count, Summarize, Filter

[Anonymous]

I want to count the API_proxies that have multiple Developer_app. In this case, 2 API_proxies have multiple developer Apps.

I know it's likely some combo of SUMMARIZE and FILTER...

API_proxy	Developer_App
Member Alerts	CRM Member Advocate Application
Member Service	CRM Member Advocate Application
Member Service	Hybrid Member Portal
Member Service	Member Portal
Oath Token	CRM Member Advocate Application
Oath Token	Hybrid Member Portal

[Greg_Deckler]

Try this:

CountOfMulitpleApps = COUNTROWS(FILTER(SUMMARIZE(Table,[API_Proxy],"MyCount",COUNT([Developer_App])),[MyCount]>1))

[Anonymous · Accepted solution]

I had to change your count to a distinctcount to get the result I wanted:

CountOfMulitpleApps =
COUNTROWS (
    FILTER (
        SUMMARIZE (
            apige_usage_test,
            [API_Proxy],
            "MyCount", DISTINCTCOUNT ( [Developer_App] )
        ),
        [MyCount] > 1
    )
)