How to divide data from two different data sources

[Anonymous]

Hi All, I am hoping you can help me out with the below query.

I have two data sources that look as below;

Table1

Table2

From 'Table1' I've created the below table;

From 'Table2' I've created the below table;

Now, I want to divide the sum of dailycount from Table1 with the count of userId per month from Table2.  e.g.   8/173,876 * 100 = 0.01%

My goal is to achieve the below table with the percentages of total;

Thanks,

[v-xiaotang]

Hi @Anonymous 

Thanks for reaching out to us.

Create a measure, and then set two variables, the first variable to get the total of each name in each month, and the other variable to get the total of the UserID corresponding to the name in each month, and then divide them.
If you need more help, please share the sample file or sample data.

Best Regards,

Community Support Team _Tang

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

[amitchandak]

@Anonymous , You can create common dimensions and then you can create a percent measure

refer:https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda