Is something wrong for Amount DAX code

[tangcy123]

Hi，

1. I add a slicer and stacked column chart.

2. slicer have parameters for Range

Range = GENERATESERIES(0, 5000, 1000)

RangeValue = SELECTEDVALUE('Range'[Range])

3. Create measure for Amount

Amount =

VAR X=ADDCOLUMNS(ALL('Order'[total_amount]),"COUNT1",CALCULATE(DISTINCTCOUNT('Order'[order_no])))

RETURN

COUNTROWS(

FILTER(

X, [COUNT1] ='Range'[RangeValue]

)

)

Question:

When Slicer move to 1000, Range =1000, then How to display the dynamic interval value? 0-1000，1000-2000，2000-3000 ... how to display the Total Amount by dynamic based on different interval value?

If Range =2000, how to dynamic display total amount?

Issue: is something wrong for Amount DAX code?

[tamerj1]

@tangcy123 

The ranges table should contain 3 columns, the range name, the min range and the max range. Then you can use IF to check the value is btween the min an max limits. 
you can use the name column to slice by in a table or slicer