Forum Discussion

BrentHamm's avatar
BrentHamm
New Member
5 years ago
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 ...
Need Help
  • StefanoGrimaldi's avatar
    StefanoGrimaldi
    5 years ago

    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 🙂 
parry2k's avatar
parry2k
Super User
5 years ago

BrentHamm what is a counter? You don't need to create an extra summary table to achieve this, the recommendation would be to create measure without adding extra table in the model.

BrentHamm's avatar
BrentHamm
New Member
5 years ago

The Venn diagram i am using is very specific requirements.  I see no way to make it work with out an extra table.

 

However, would love a solution that did not need it.