Using SWITCH to show previous field value

[Anonymous]

Hi,

I have this list:

Sprint 1

Sprint 2

Sprint 3

Sprint 4

Sprint 5

Each of the sprints has Story Points associated (Numbers)

For each Sprint , I need the SUM of Story Points of the PREVIOUS Sprint. (For example, for Sprint 2, I need the sum of Story Points of Sprint 1)

So for that, I am using SWITCH, to bring the Sprint Name and the measure of the SUM of Story Points for the PREVIOUS Sprint:

This is an example of the measures I have created

Notice that in the SWITCH , I am calling the Sprint name with the measure of the previous Sprint,

I put the Zero just because I was testing, but, any ideas why is not working ? it is showing blank values.

Thanks in advance.

[az38 · Accepted solution]

@Anonymous 

hi. as you use a measure that enables row-context use a ALL() inside FILTER, like

SUMX(FILTER(ALL(RSRI),RSRI[Sprint Name]=....

[mwegener]

Hi @Anonymous ,

if you want to learn more about this, read this blog post "Understanding Context Transition"

https://www.sqlbi.com/articles/understanding-context-transition/

[az38 · Accepted solution]

@Anonymous 

hi. as you use a measure that enables row-context use a ALL() inside FILTER, like

SUMX(FILTER(ALL(RSRI),RSRI[Sprint Name]=....

[Anonymous]

Thanks @az38 😎

[az38 · Accepted solution]

@Anonymous 

did you check it? I'm already not sure this works, maybe your issue is more complicated

[Anonymous]

yes, it is working with that change, thanks!