Forum Discussion

ezzz_'s avatar
ezzz_
New Member
3 years ago

bridge table and sumx helppp

I have two tables and bridge tables, How can I use sumx for 'getTimeLogs'[hours_spent]*'getTClientRateHistory '[client_rate],

pbi cant see the relation between getTClientRateHistory and getTimeLogs tables. I try to set that relation between a bridge table,but it didn't work 

 

 

 

 

hel

7 Replies

  • mlsx4's avatar
    mlsx4
    Icon for Memorable Member rankMemorable Member
    3 years ago

    Hi ezzz_ 

    Try something like: 

    Revenues=
SUMX( CROSSJOIN(getTimelogs,getTClientRateHistory),
getTimelogs[hours_spent]*getTClientRateHistory[client_rate])

     

    • ezzz_'s avatar
      ezzz_
      New Member
      3 years ago

      thanks but it didnt work again, pbi couldnt find getTClientRateHistory

       

      • mlsx4's avatar
        mlsx4
        Icon for Memorable Member rankMemorable Member
        3 years ago

        And what if you try three measures?:

        sumHourSpent = SUM(getTimeLogs'[hours_spent])
sumClientRateHistory = SUM(getTClientRateHistory '[client_rate])
mutiply = [sumHourSpent]*[sumClientRateHistory]

         

  • technolog's avatar
    technolog
    Icon for Super User rankSuper User
    2 years ago

    I hope this message finds you well. I've noticed that this solution remain unresolved. If any of you have managed to find a resolution to the issue, I kindly request that you share your solution for the benefit of the entire community. Alternatively, if you're still facing challenges, please do let us know as well.

    Your insights and updates will greatly assist others who might be encountering the same challenge.