Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Comparing two tables without relationship using a venn diagram, measure not showing values

I'm trying to produce a venn diagram to show differences of what products a customer has uploaded to their systems. But my venn diagram is not working with the follwing measure.       Produ...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi Anonymous ,


    I seem to have some trouble understanding it. According to your test data, for the INTERSECT function returns a table that contains only the rows that are present in both table expressions as arguments. Thus causing the result returned by your formula to be empty.

    A situation similar to the following is required:


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Overlap = COUNTROWS(INTERSECT(VALUES(CustomerFile[ProductCode]),VALUES('Product File'[ProductCode])))

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you can I add a slicer on this as I have different customers and these customers are in different countries, how can I do that would Ihave to have slicers for each product file and customer file?

     

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      4 years ago

      Yes, the simple way is to have separate slicers.