Measures

[amandabus21]

Hello,

Im having trouble creating a mesaure from two differenet tables. 

I need Ridership/ Act in Serv Hours.

 I need it by year and month.

For example August 2022 for Circulator = 63286/6846 = 9.24.

But when I create a measure using the it only gives me the grand total of August, not breaking it down by the service. 

[amandabus21]

Additionally when I go to the original matrix and click on the month and service, it will show me what I need. How can I get it to stay that way?

[amitchandak]

@amandabus21 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

If both tables are joined with a common date table then your measure Divide(Sum(Table1[Val]), Sum(Table2[Val])) should work