Hi everyone,
I have DevOps Roll up Data that I have been building based on Azure DevOps Work Item Hierarchy Reports in PowerBI (colinsalmcorner.com)
I created calculated column for each User story with Closed state and overall count of user stories and then I created the % of Closed stories to show the completion state of the parent. The problem is I want the related children calculation to ingore the slicer applied on the Parent.
One screenshot has no (all) applied and it behaves the way I wasnt it apart from losing data through slicing.
Second screenshot has (all) applied bu tthen i eneded up with count of all user stories per column total rather than per row.
I tried to make count of closed children and total as measures - but it did not behave the way I wanted them - so I used calculated columns - but now having problems with Slicers. Where is my dax wrong? Thanks!
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
