cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ronrule Regular Visitor
Regular Visitor

DAX count, Summarize, Filter

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_proxyDeveloper_App
Member AlertsCRM Member Advocate Application
Member ServiceCRM Member Advocate Application
Member ServiceHybrid Member Portal
Member ServiceMember Portal
Oath TokenCRM Member Advocate Application
Oath TokenHybrid Member Portal
1 ACCEPTED SOLUTION

Accepted Solutions
ronrule Regular Visitor
Regular Visitor

Re: DAX count, Summarize, Filter

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
    )
)
2 REPLIES 2
Super User
Super User

Re: DAX count, Summarize, Filter

Try this:

 

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

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


ronrule Regular Visitor
Regular Visitor

Re: DAX count, Summarize, Filter

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

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 232 members 2,402 guests
Please welcome our newest community members: