Dynamic Filters

[Anonymous]

For example, I have a column A with numbers, and I want to calculate +/- X% of Column A. I would like two have two slicers one as a drop for X% (5%, 10%, 15%, etc) and another slicer which will give me the range of (Column A - X% * Column A) -- (Column A + X% * Column A)

Could someone help me with this? TIA!

[v-jayw-msft]

Hi @Anonymous ,

Are you saying that if i select 5% in slicer it will returen both value * (1+5%) and value * (1-5%), if i select 10% in slicer it will returen both value * (1+10%) and value * (1-10%)?

If so you could create a table and measures as below.

Measure = SELECTEDVALUE('Table'[A])*(1+SELECTEDVALUE(slicer[+%]))

Measure 2 = SELECTEDVALUE('Table'[A])*(1+SELECTEDVALUE(slicer[-%]))

 

Result would be shown as below.

If i misunderstood your meaning, please show more details.

Best Regards,

Jay

[Anonymous]

@v-jayw-msft so I did create a table to show something similar to what you have done. Let's say I have a KeyID associated for every record in that table, so I want to first select a single KeyID and when  I do that I want a Slicer that can represent  lower bound (Measure) and the upper bound (Measure 2)

Something like this

For now, the slicer is not Dynamic, it just gets the Max and Min value of Column A. Would be nice to have it dynamic.

[Anonymous]

[amitchandak]

@Anonymous , Can you share sample data and sample output in table format?

[Anonymous]

Would this suffice @amitchandak ?

A	+10%	-10%
10	11	9
20	22	18
30	33	27

 

[amitchandak]

@Anonymous , if the slicer is on % column

measure =
var _max =selectedvalue(slicer[value])
return
calculate(sum(Table[A])*(1+_max))

Absolute number

measure =
var _max =selectedvalue(slicer[value])
return
calculate(sum(Table[A])*((1+_max)//100))