Forum Discussion
Overlap Count Measure
- 1 year ago
| Name | Month | MonthNum | Month-2 |
| Joy | Jan | 1 | Jan |
| Nita | Jan | 1 | Jan |
| Goks | Jan | 1 | Jan |
| Joy | Feb | 2 | Feb |
| Sophie | Feb | 2 | Feb |
| Sage | Feb | 2 | Feb |
| Serena | Mar | 3 | Mar |
| Sophie | Mar | 3 | Mar |
| Sage | Mar | 3 | Mar |
| Nita | Apr | 4 | Apr |
| Joy | Apr | 4 | Apr |
| Pappu | Apr | 4 | Apr |
| Goks | May | 5 | May |
| Pappu | May | 5 | May |
| Joy | May | 5 | May |
| Jade | Feb | 2 | Feb |
| Paddy | Mar | 3 | Mar |
| Jamin | Feb | 2 | Feb |
Thank you so much Ashish_Mathur and lbendlin. I have uploaded the sample data as a table here. So, I am trying to recreate what a Venn diagram would do. Below I show the result I expect as a screenshot. By choosing 2 different months in the slicers, the red box should display the number of names that appear in both months as selected in the slicers. I am able to get the green boxes right. It's the red one that is an issue. So far I have found that if I duplicate the 'Names' table and use the 'month' fields from 2 different tables for the month-slicers then the red box gives me the correct output. I'd like to know if I can acheive the same result without duplicating the table. Thank you. FYI - I have pasted the DAX code for the 'overlap measure' in my earlier post.
Hi,
I have solved a similar question in the attached file.
- freebird281 year agoHelper I
Thank you so much Ashish_Mathur It was helpful.
- Ashish_Mathur1 year agoSuper User
You are welcome.