Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Single Value Error

Hi All,   I have two data sets as per the below examples;   Task ID Hire Duration (Days) 1 10 2 100 3 12 4 5   Task ID Hire Cost (£) 1 10 2 100 3 700 4...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Fowmy's avatar
    Fowmy
    6 years ago

    Anonymous 

    You can use the same Measure I shared or use the following. The difference is when you have one ID the results from both are same but in times of multiple IDs, the prior Measure with Average X will average and later will sum.

    Hire Cost = 
SUMX(
    Job_card_detail_tbl,
    Job_card_detail_tbl[Hire Cost (£)] * 
    LOOKUPVALUE(
        'Standing Scaffold Data'[Hire Duration (Days)],
        'Standing Scaffold Data'[Task ID],
        Job_card_detail_tbl[Task ID]
    )
)

     

    ________________________

    Did I answer your question? Mark this post as a solution, this will help others!.

    Click on the Thumbs-Up icon on the right if you like this reply 🙂

    YouTube, LinkedIn

Fowmy's avatar
Fowmy
Super User
6 years ago

Anonymous 

Use the following measure to get the average cost

Total Hire Cost = 
AVERAGEX(
    Job_card_detail_tbl,
    Job_card_detail_tbl[Hire Cost (£)] * 
    LOOKUPVALUE(
        'Standing Scaffold Data'[Hire Duration (Days)],
        'Standing Scaffold Data'[Task ID],
        Job_card_detail_tbl[Task ID]
    )
)



________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Fowmy ,

     

    Thanks for your response, that has worked. Do you have a solution for enabling me to see individual hire cost (hire cost * hire duration) that can used on a tooltip for my map visual?

     

    Thanks,

     

    E

    • Fowmy's avatar
      Fowmy
      Super User
      6 years ago

      Anonymous 

      You can use the same Measure I shared or use the following. The difference is when you have one ID the results from both are same but in times of multiple IDs, the prior Measure with Average X will average and later will sum.

      Hire Cost = 
SUMX(
    Job_card_detail_tbl,
    Job_card_detail_tbl[Hire Cost (£)] * 
    LOOKUPVALUE(
        'Standing Scaffold Data'[Hire Duration (Days)],
        'Standing Scaffold Data'[Task ID],
        Job_card_detail_tbl[Task ID]
    )
)

       

      ________________________

      Did I answer your question? Mark this post as a solution, this will help others!.

      Click on the Thumbs-Up icon on the right if you like this reply 🙂

      YouTube, LinkedIn