Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 =
Solved! Go to 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/
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/
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |