Ovelapping subdimension or venn diagram like table

[Anonymous]

I need to get venn diagram like data in the table. The data will be created based on the selections made by user. How do I show overlapping data based on the sub-dimension that is not visible to user. My data and expected output is given below.

[Ashish_Mathur · Accepted solution]

Hi,

Can you live with this.  Download my PBI file from here.

Hope this helps.

[Anonymous]

Hi Ashish

Thanks for the reply. The solution seems to work, but I m not able to see the formuals behild the calculation. I have only power bi desktop and excel is not showing any formulas. Is there any other way you can to share the solution like .pbix file?

[Ashish_Mathur]

Hi,

In PowerBI desktop, go to File > Import > Excel workbook.

[Anonymous]

Thanks Ashish for your timely help.

[Ashish_Mathur]

You are welcome.