Tag orderlines with the same salestime in each order

[Trolleri]

Hello,

I have a order table where each product in an order has their own orderrow.

Im trying to tag all orderrows in an order that has the same salestime, so for example, if i have an order with 4 items and 3 of them was sold at the same time, i want those marked. I only want this behaviour if it is 2 or more rows in an order with the saletime.

so the table consists of the following rows:

order_id,orderrow_id,product_id,quantity,price,salestime

Any ideas?

[v-henryk-mstf · Accepted solution]

Hi @Trolleri ,

According to your description, you can create a calculated column to count the number of rows under an order that meet the sales time on the same day greater than 2. Then apply a custom background-color to order_id. refer to the following test results.

row_ =
CALCULATE (
    COUNTROWS ( 'Table' ),
    ALL ( 'Table' ),
    'Table'[order_id] = EARLIER ( 'Table'[order_id] )
        && 'Table'[salestime] = EARLIER ( 'Table'[salestime] )
)

If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PC2790]

You can consider using RANKX function.

How to use RANKX in DAX (Part 1 of 3 - Calculated Columns) - RADACAD

If you can provide your sample data and the required result set, I can provide you with the solution.