Filtering down a graph based on a selection

[Anonymous]

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!

[lbendlin]

Don't use SELECTEDVALUE inside CALCULATE (read about filter context, and context transition).  Use variables.

[Anonymous]

Hello, thank you for the ideas. Can you help me write a Dax measure with those? I have started something like this:

Thank you!

[lbendlin]

Specifying multiple filter conditions in CALCULATE - SQLBI