Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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
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
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.