Matrix showing totals in all cells

[Anonymous]

I am having trouble with a matrix where is showing only the totals in every cell.  I am using two summarized tables together.  This the DAX code for the tables:

Credits table:

MonthlyActivationsP = 
SUMMARIZECOLUMNS(
	'All Licenses'[Primary Sales Rep],'All Licenses'[Year-Month A], "Primary Share"
,If(ISBLANK('All Licenses'[MonthActivationsPShare]),0,
Sum('All Licenses'[MonthActivationPShare])
	
))

Charges Table:

MonthlyDeactsP = SUMMARIZECOLUMNS(
	'All Licenses'[Primary Sales Rep],'All Licenses'[Year-Month D], "Primary Share Deact"
,if(ISBLANK([MonthDeactPShare]),0,
Sum('All Licenses'[MonthDeactsPShare])
	
))

Tables fields:

I am trying to put in a matrix both totals by Year/Month (top matrix) and this is what is doing.

[alexvc · Accepted solution]

Hi there,

Did you create a relationship between these two tables? It seems to me there could be a problem with it, since both visualizations of each table per separate are ok but the visualization using both tables is not. From what I see you should have a third table where you have all the records of PrimarySalesRep and create a relationship between this and your Credits and Charges table

Let me know if it works

Alejandro

[Anonymous]

Thank you Alejandro!  The third table solved my problem.  I used the DAX UNION function, making sure to create the fields that were going to match complement in both tables existed. 

CreditsCharges = UNION(MonthlyActivationsP,MonthlyDeactsP)

Have a great weekend!

-Vanessa

[Anonymous]

I'll be trying the third table, and yes both tables have a relationship between their YYYY-MM and the Sales Rep.  Wish me luck.  

Thank you for your time.