Forum Discussion

amandabus21's avatar
amandabus21
Icon for Helper V rankHelper V
3 years ago

Measures

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/684...
amandabus21's avatar
amandabus21
Icon for Helper V rankHelper V
3 years ago

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's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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