Forum Discussion

KBD's avatar
KBD
Icon for Helper III rankHelper III
1 year ago

calc a rolling rate

Hello:    Returning to the folks who know a little bit more that I do. I am struggling to calc a running rate.  I have to be able to calc this rate over dynaminc (user selected via a slicer ) per...
Need Help
KBD's avatar
KBD
Icon for Helper III rankHelper III
1 year ago

Making it even simpler:

Look at the following.

Using the Power BI sheet Rolling II   link is in this trail

 

This works:

tstDivide = calculate(  sumx( goalAssist,  goalAssist[minutes played] + goalAssist[minutes played]  ) , FILTER (AllSelected(goalAssist[yyyymm]), goalAssist[yyyymm] <= MAX(goalAssist[yyyymm]) ) )

and this works:

tstDivide = calculate(  sumx( goalAssist,  goalAssist[minutes played] * 2  ) , FILTER (AllSelected(goalAssist[yyyymm]), goalAssist[yyyymm] <= MAX(goalAssist[yyyymm]) ) )

 

but this does not  

tstDivide = calculate(  sumx( goalAssist,  goalAssist[minutes played] / goalAssist[minutes played]  ) , FILTER (AllSelected(goalAssist[yyyymm]), goalAssist[yyyymm] <= MAX(goalAssist[yyyymm]) ) )

this should return one all day every day, but does not.

Multiplication is also bad.    Strange.  

 

Just create tstDivide in the Power BI.

 

Thanks for your attention to this matter.

 

KBD