Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Help -Convert Converted Column to measure

I have this  Calculated Column that I use in a Stacked Column chart.   Works great but it does not react to the Slicer I have.   COUNTROWS(FILTER (ALLSELECTED(AllWorkItems),                     ...
Need Help
  • MFelix's avatar
    MFelix
    3 years ago

    Hi Anonymous ,

     

    Based on what you wrote, you have the Feature table just to calculate the count of the values, ytou have two options with a basic measure.

     

    Create the following measure:

    Count of activities = COUNTROWS(FILTER (AllWorkItems,
                                         AllWorkItems[Story Type] = "User" &&
                                         AllWorkItems[Is Current] = TRUE()  &&
                                         AllWorkItems[State] in { "CLOSED" , "ACCEPTED", "RESOLVED"} ))

     

    Be aware that I needed to adjust the code for the sample you send out to me now you can:

     

    1. Keep the Features table, do a relationship between both table by (One to many : FeatureID -> ParentID) and use the X-axis from the Feature ID
    2. Delete the Features table and use the Parent ID from the original table has your x-axis has you can see result is equal on any option

     

    See the PBIX attach.

     

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

AllWorkItems will look something like this

 

ID     Story type     State     Parent Id     Is Current

1       Feature          OPEN       0                  Yes

2      User Story       Open       1                  Yes

3      User Story       Closed     1                  Yes

4       Feature          OPEN       0                  Yes

5      User Story       Open       1                  Yes

6      User Story       Closed     1                  Yes

 

 

 

I created the Feature Table ONLY because I wanted to get a list of Features in my Stacked Column chart then  Count all the User stories per feature by status

So I created a new table of all the Features and did Calculated Columns counting the stories by state.

MFelix's avatar
MFelix
Super User
3 years ago

Hi Anonymous ,

 

Based on what you wrote, you have the Feature table just to calculate the count of the values, ytou have two options with a basic measure.

 

Create the following measure:

Count of activities = COUNTROWS(FILTER (AllWorkItems,
                                         AllWorkItems[Story Type] = "User" &&
                                         AllWorkItems[Is Current] = TRUE()  &&
                                         AllWorkItems[State] in { "CLOSED" , "ACCEPTED", "RESOLVED"} ))

 

Be aware that I needed to adjust the code for the sample you send out to me now you can:

 

  1. Keep the Features table, do a relationship between both table by (One to many : FeatureID -> ParentID) and use the X-axis from the Feature ID
  2. Delete the Features table and use the Parent ID from the original table has your x-axis has you can see result is equal on any option

 

See the PBIX attach.