Forum Discussion
distinct SUMMARIZE
I have formula
CALCULATETABLE(
SUMMARIZE(_op,[apyv_id],_OP[Column]),
FILTER (
_OP,
[P] <> 1
),
FILTER (
_OP,
NOT ISBLANK ( _OP[apyv_id] )
),
FILTER (
'ACC',
[Sas] = "1111"
)
)
Column '' in Table '' contains a duplicate value '770' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
How to delete dublictaes on [apyv_id]?
1 Reply
Remove duplicate rows in Power Query or use DISTINCT/VALUES/ALL in DAX.
