How to show division of two columns from different table in chart for the category

[gaurav21791]

I have a chart that is group/categorized by month and year(Start Date column from table 1). I have two tables (Table 1 and Table 2) where both have the Start Date column. I want to show the division of the sum of amount column from Table 1 and the running total of the count of rows per category i.e. grouped by month and year.   

Please let me know how can achieve this. Thanks for your help in advance. 

[Anonymous · Accepted solution]

@gaurav21791 
I assumed you have a model with correct relationship, you can create the following measure and put on the graph in the values field.

Measure = Divide(
Sum(Table1[Amount]), 
Calcuate(countrows(table2),Filter(Allselected(table2), [Date]<=MAX([Date])&&[Cateogry]=Max(Category])))
)

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[PaulDBrown]

Please follow the recommendations outlined in this thread:

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523