Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filtering Chart by two values

Hello Folks.   I'm trying to filter a chart by two values.   Rules: If actual velocity projection is greater than total stories then i won't show others sprints   Can anyone help me? Is t...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • d_gosbell's avatar
    d_gosbell
    6 years ago

    I think you will have to do this by creating 2 new measures for your chart. For the Total Stories measure the "trick" is to return the value of the base [Total Stories] measure if we are looking at only one sprint and the value of Total Stories is greater than the actual velocity projection

     

    Total Stories for Chart = IF( HASONEVALUE( 'Sprint Table'[Sprint Name] )
, IF( [Total Stories] > [Actual Velocity Projection], [Total Stories] , BLANK() )
, [Total Stories])

    For the velocity you'd follow a similar pattern, just check if the velocity is less than the total stories, otherwise return blank.

    Actual Velocity Projection for Chart = IF( HASONEVALUE( 'Sprint Table'[Sprint Name] )
, IF( [Actual Velocity Projection] < [Total Stories], [Actual Velocity Projection] , BLANK() )
, [Actual Velocity Projection])
d_gosbell's avatar
d_gosbell
Super User
6 years ago

I think you will have to do this by creating 2 new measures for your chart. For the Total Stories measure the "trick" is to return the value of the base [Total Stories] measure if we are looking at only one sprint and the value of Total Stories is greater than the actual velocity projection

 

Total Stories for Chart = IF( HASONEVALUE( 'Sprint Table'[Sprint Name] )
, IF( [Total Stories] > [Actual Velocity Projection], [Total Stories] , BLANK() )
, [Total Stories])

For the velocity you'd follow a similar pattern, just check if the velocity is less than the total stories, otherwise return blank.

Actual Velocity Projection for Chart = IF( HASONEVALUE( 'Sprint Table'[Sprint Name] )
, IF( [Actual Velocity Projection] < [Total Stories], [Actual Velocity Projection] , BLANK() )
, [Actual Velocity Projection])