Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Filtering down a graph based on a selection

Hello all.

 

I am new to PBI and I am trying to filter the graph marked with the arrow based on the selection highlighted in the image bellow

 

I have developed two measures that clearly are wrong (same logic so I only posted one) and I am getting the folowing warning: ðŸ˜…

 

How can I correct the measure? I want to sum the total hours that are posted in the days that are between the time range based on the Sprint number of the selection.

 

I have a Date table with all dates, connected to the Posting Date and both the Iteration Started and Finish Dates. An example of the tables is bellow to help to understand the model.

 

Devops table:

 

Nav Total table:

 

Thanks in advance!