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