Filtering Chart by two values

[Anonymous]

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 that possible?

TY guys

[d_gosbell · Accepted solution]

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])