Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 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.

     

     

     

MFelix's avatar
MFelix
Super User
3 years ago

Hi Anonymous ,

 

Try the following code:

 

ddd =
COUNTROWS (
    FILTER (
        ALLSELECTED ( AllWorkItems ),
        AllWorkItems[Work Item Type] = "User Story"
            && AllWorkItems[Is Current] = TRUE ()
            && AllWorkItems[Parent Work Item Id]
                in Values ( 'Features Table'[FeatureID] )
            && AllWorkItems[State] IN { "CLOSED", "ACCEPTED", "RESOLVED" }
    )
)

Be aware that this may need adjustments, and depends on the context you are using in the visualization.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks for the reply..  I am not getting any results.. but dont get an error.   

     

    The FeatureID is the X Axis of the Stacked Column chart  So I am trying to get the count for each column..ie each Feature ID  I have

     

    • MFelix's avatar
      MFelix
      Super User
      3 years ago

      Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

      If the information is sensitive please share it trough private message.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 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.