Forum Discussion
Ignore Slicer for calculated column
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!
1 Reply
- Fowmy
Super User
Instead of ALL, Try
ALLSELECTED('USER STORIES')