COUNTX gives same proportion

[Dunner2020]

Hi there,

I am trying to display the count of applications w.r.t their age (how many days/weeks since application lodged) in pie chart. I created the following measure 

In progress application = 

COUNTX( FILTER(ALL('Main Table'),'Main Table'[Cases__r.Status] = "Awaiting Endorsement/Verification"),'Main Table'[App_ID])

I used All statement because I don't want to apply any existing filters of the page on the calculation.

When I displayed the above measure in the pie chart it shows an equal proportion of all age categories as shown in the picture:

I am not sure where I made the mistake. Any help would be really appreciated.

Data here

[VahidDM · Accepted solution]

Hi @Dunner2020 

Try this:

In progress application =
CALCULATE (
    COUNT ( 'Main Table'[App_ID] ),
    FILTER (
        ALLEXCEPT ( 'Main Table', 'Main Table'[Application Age] ),
        'Main Table'[Cases__r.Status] = "Awaiting Endorsement/Verification"
    )
)

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/