Hi @ErikOmni ,
Please try below steps:
1. below is my test table
2. create a measure with below dax formula
Order Range =
VAR cur_sale =
SUM ( 'Table'[Sales] ),
'Table'[OrderID] = SELECTEDVALUE ( 'Table'[OrderID] )
cur_sale > 1000, ">1000",
cur_sale > 600
&& cur_sale < 1000, "600-1000",
cur_sale < 600, "<600"
3. add a table visual with fields and measure
Please refer the attached .pbix file.
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.