Forum Discussion

jimmymartin's avatar
jimmymartin
Regular Visitor
4 years ago
Solved

Calculated Measure using result based on another column

Hi, I have a data set with list of sports teams and their actions during a game. I have a column for team and a column for their opposition and a calculated measure for number of tackles. Is there a ...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi jimmymartin ,

    According to your description, in my understanding, there're two tables in your sample,

    Team table:

    Opposition table:

    Then create a measure to extrat the tackles of the opposition team, if this is the case, here's my solution, use the lookupvalue-function to create a measure.

    Opposition Tackles =
LOOKUPVALUE (
    Opposition[Tackles],
    'Opposition'[Oppositon], MAX ( 'Team'[Team] )
)

    Get the result.

    I attach my sample below for reference.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi jimmymartin ,

According to your description, in my understanding, there're two tables in your sample,

Team table:

Opposition table:

Then create a measure to extrat the tackles of the opposition team, if this is the case, here's my solution, use the lookupvalue-function to create a measure.

Opposition Tackles =
LOOKUPVALUE (
    Opposition[Tackles],
    'Opposition'[Oppositon], MAX ( 'Team'[Team] )
)

Get the result.

I attach my sample below for reference.

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.