Forum Discussion
Solved
Dynamic range in calculated column
Hi every one. I really enjoy this forum an i serch it frequently for solutions to problems i encounter. This time i am realy struggling with something. I have calculated table in which i am cons...
Hi everyone. I actually find a way to deal with the problem. The solution is to creat separate table with needed ranges and use "SELECTEDVALUE" as a part of the filter in "CALCULATE" function. For example:
Order value =CALCULATE(SUM(Summary (day)'[Order value]),'Summary (day)'[Order value]<=SELECTEDVALUE('Active slicing'[Order value]))As a result i can use slicer to actively change the sum ranges associated wiht the value in calculated table.
Hi everyone. I actually find a way to deal with the problem. The solution is to creat separate table with needed ranges and use "SELECTEDVALUE" as a part of the filter in "CALCULATE" function. For example:
Order value =
CALCULATE(
SUM(Summary (day)'[Order value]),
'Summary (day)'[Order value]<=SELECTEDVALUE('Active slicing'[Order value]
))
As a result i can use slicer to actively change the sum ranges associated wiht the value in calculated table.