Forum Discussion

tangcy123's avatar
tangcy123
Helper I
4 years ago

Is something wrong for Amount DAX code

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?

 

 

Need Help

1 Reply

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    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