Forum Discussion

amandabus21's avatar
amandabus21
Helper 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/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. 

 

 

 

2 Replies

  • amandabus21's avatar
    amandabus21
    Helper 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
      Super 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