How to let amount and count dynamic change by range in slicer

[tangcy123]

Hi,

I add a slicer for amount range,  increment value =200,  then I add visual for Amount and Count, how to let  Amount and Count dymanic change by range? 

eg: if range = 1400, then display total amount and total count where amount is equal or less than 1400.

if range = 2000, then display total amount and total count where amount is equal or less than 2000.

[amitchandak · Accepted solution]

@tangcy123 ,

If you need to filter the amount column

Countrows(filter(Table, Table[Amount] <= selectedvalue(whatif[value]) ))

Amount m=

calculate( Sum(Table[Amount]), filter(Table, Table[Amount] <= selectedvalue(whatif[value]) ))

[tangcy123]

Thank you very much, it resoved my question😀