Forum Discussion

bbajuscak's avatar
bbajuscak
Icon for Helper I rankHelper I
1 year ago
Solved

Display Differences Between 2 Matrices

I have 2 seperate matrices, each built from different data sources, using different tables and table structures. Tables making up each matrix are not related to one another. Each matrix is a heirarc...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    You will want to clean this up as it will have a massive impact on performance.

     

    Here is the general approach for the comparison

     

     

    DEFINE
	VAR a = SELECTCOLUMNS(SUMMARIZECOLUMNS(
							'KI - Epics'[Initiative Name],
							'KI - Epics'[Project Name],
							'KI - Story'[Key + Status],
							'KI - Epics'[Key + Status]),
			"Column1", 'KI - Epics'[Initiative Name],
			"Column2", 'KI - Epics'[Project Name],
			"Column3", 'KI - Story'[Key + Status],
			"Column4", 'KI - Epics'[Key + Status])
	VAR b = SELECTCOLUMNS(SUMMARIZECOLUMNS(
							'Initiatives - Issues'[SUMMARY],
							'Project - Issues'[SUMMARY],
							'Epics - Issues'[Key + Status],
							'Stories - Issues'[Key + Status]),
			"Column1", 'Initiatives - Issues'[SUMMARY],
			"Column2", 'Project - Issues'[SUMMARY],
			"Column3", 'Epics - Issues'[Key + Status],
			"Column4", 'Stories - Issues'[Key + Status])
EVALUATE
	EXCEPT(a,b)

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

Use EXCEPT().

 

If you like help please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523