Forum Discussion

uniqum47's avatar
uniqum47
Frequent Visitor
5 years ago

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

  • Instead of ALL, Try 

    ALLSELECTED('USER STORIES')