cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mflorian Frequent Visitor
Frequent Visitor

Wrapping Distinct around a union

I have created three summary tables that pulls revenue information from three disparate systems for a consolidated report. Two of the tables have the potential for duplicate data due to a data classification problem that is currently being worked on. In the meantime, we need to create a data set for the user to report from.

 

The union statement works fine but it returns duplicate rows when the two systems have the same data. I have set all data fields for the three summaries to be the same in SSAS. When I wrap a distinct around the union, I get the same results as if the union was not there.

 

Here is the DAX:

=DISTINCT(UNION('Table A, 'Table B', 'Table C'))

 

Is there a better way to accomplish this? It seems straight forward but ... nothing ever is.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Wrapping Distinct around a union

Hi,

 

You may append data using Query Editor and then select all column > Right click > Remove Duplicates > Close and Load.

View solution in original post

1 REPLY 1
Super User
Super User

Re: Wrapping Distinct around a union

Hi,

 

You may append data using Query Editor and then select all column > Right click > Remove Duplicates > Close and Load.

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 114 members 1,598 guests
Please welcome our newest community members: