I have a dataset with order rows, with a unique ID for each order. I want to be able to create a column/tag for each orderID with a designated order value range.
See below for how the dataset looks like and what I would like to achieve.
Go to Solution.
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.
Best regards,Community Support Team_Binbin YuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
Create measures like below,
Order Value = SUM(tablename[Sales])
Order Range = SWITCH(
[Order Value] > 1000, "> 1000",
AND([Order Value] > 600, [Order Value] < 1000),"600-1000",
@v-binbinyu-msft Hi! Sorry for late reply. The solution worked, however, I realized I need it to be column to allow me to track YoY development into different buckets.
This formula give me a circular reference warning when I try to apply it as a measure.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.