Hi! Is there a way to prevent duplicates in a virtual column type list? I would like to prevent duplicates just in the current order, (If I already picked apple, I should not add apple again?)
Thanks
Solved! Go to Solution.
I belive that Order Details column is a reverse-ref (isPartOf property of your Ref set to TRUE). If so;
you can set a valid_if expression in your child table for that [Fruit] column. Please make necessary changes in the expression to fit in your table schema.
COUNT(
SELECT(
Orders[Fruit],
AND(
[_THISROW].[Fruit] = [Fruit],
[_THISROW].[RefColName] = [RefColName]
)
)
) = 0
I belive that Order Details column is a reverse-ref (isPartOf property of your Ref set to TRUE). If so;
you can set a valid_if expression in your child table for that [Fruit] column. Please make necessary changes in the expression to fit in your table schema.
COUNT(
SELECT(
Orders[Fruit],
AND(
[_THISROW].[Fruit] = [Fruit],
[_THISROW].[RefColName] = [RefColName]
)
)
) = 0
Thanks, I think it will be the solution, but I donโt know where my mistake is. If I understand, It will count Product (fruit) in Orders, but in my Orders table I donโt have a Product Column.
Yeah, It works! thanks
Youโre welcome
hi bro, can you share how to enter the formula? I have the same problem as you, but Iโm still confused to solve it
This an old topic. Please start a new topic with a detailed explanation of your problem.
hi steve, can you help me, I want to filter the order details to remove duplicates in the [menu id] column, can it be done?
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |