Forum Discussion

Dunner2020's avatar
Dunner2020
Post Prodigy
4 years ago
Solved

COUNTX gives same proportion

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 applicatio...
Need Help
Show and Tell
Tips and Tricks
  • VahidDM's avatar
    VahidDM
    4 years ago

    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/

     

     

VahidDM's avatar
VahidDM
Super User
4 years ago

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/