Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    Try this:

     

    CountOfMulitpleApps = COUNTROWS(FILTER(SUMMARIZE(Table,[API_Proxy],"MyCount",COUNT([Developer_App])),[MyCount]>1))
    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

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