Forum Discussion

IanSwanepoel's avatar
IanSwanepoel
Helper I
8 years ago
Solved

Data from a indirect relationship.

Hi Guys, I'm having trouble viewing data over indirect relationships Above is a view of the relationships. Every Branch has multiple employees, but some employees also belong to more t...
Need Help
  • IanSwanepoel's avatar
    IanSwanepoel
    8 years ago

    I managed to solve the issue doing the following:
    I created a measure that sums up the Rate
             ValueSumRate = SUM(Rates[Rate])
    And then I proceeded to SumX that value by its lowest possible level, being User
             UserCost = SUMX(User,[ValueSumRate])
    Now regardless of how I display the value it always calculates the rates based on the lowest possible value.

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi IanSwanepoel,

 



For example if users in that branch use Sys1 and Sys2 which cost 100 and 200 respectively it gives a value of 300, seeing as there are example 10 users I need it to give me,  the (5 users using Sys1)*(100) and the (5 users using Sys2)*(200)

Have you tried adding the user column into table visual?

 

Regards,

Yuliana Gu