Hello,
My understanding was that Distinct Union would remove duplicate rows, however I keep getting duplicate rows. Was hoping there might be something simple that someone could point out that is incorrect. Thanks for any tips!
In the below example, I'll get the following row twice:
United States, Hardware, $500
DEFINE
VAR Table1=
SUMMARIZECOLUMNS(
'Sales Structure'[SLS LVL 1],
'Product Table'[Product 1],
KEEPFILTERS( TREATAS( {"United States"}, 'Sales Structure'[SLS LVL 1] )),
"Orders Revenue", [Orders Revenue]
)
VAR Table2=
SUMMARIZECOLUMNS(
'Sales Structure'[SLS LVL 1],
'Product Table'[Product 1],
KEEPFILTERS( TREATAS( {"Hardware"}, 'Product Table'[Product 1] )),
"Orders Revenue", [Orders Revenue]
)
VAR UnionTable = Union(Table1,Table2)
VAR Output = Distinct(UnionTable)
Evaluate
Output
