Forum Discussion
Solved
Creating a Summary table from two fact tables
I am struggling with the dax to create a summary table (in red box) from a purchase and invoice table as shown below. The data needs to be in this format for the venn digram to function. I also ...
try something like this:
summary table = SUMMARIZE(Accounts,Accounts[ID],"HasInvoice",IF(CALCULATE(COUNT(Invoices[Invoice ID]))>0,1,0),"haspurchase",IF((CALCULATE(COUNT(Purchases[Purchase ID])))>0,1,0))then add a column as follow for the counter on the new table:counter = if(and(summary table[ hasinvoice]=1,summary table[haspurchase]=1),1,0)if this helped solve your question please masrk as solution, and if if like the solution give kudos 🙂
try something like this:
summary table = SUMMARIZE(Accounts,Accounts[ID],"HasInvoice",IF(CALCULATE(COUNT(Invoices[Invoice ID]))>0,1,0),"haspurchase",IF((CALCULATE(COUNT(Purchases[Purchase ID])))>0,1,0))
then add a column as follow for the counter on the new table:
counter = if(and(summary table[ hasinvoice]=1,summary table[haspurchase]=1),1,0)
if this helped solve your question please masrk as solution, and if if like the solution give kudos 🙂
That is exactly what i wanted, and i was close. Thanks so much!!