Forum Discussion

sjpaq's avatar
sjpaq
Helper I
2 years ago
Solved

DAX help please

I have a table called ResponseCosts. There is a column called Hours and another column called Rank. A second table RankHourlyRates keyed on Rank provides the Hourly Rate. Total cost for a given row ...
Need Help
  • sjpaq's avatar
    sjpaq
    2 years ago

    No responses, I think I have figured this out.

    I changed the DAX formula to the following:

    ExtendedCost =
        SUMX(ResponseCosts, ResponseCosts[Hours] *
                LOOKUPVALUE ('RankHourlyRates'[Hourly Rate],
                'RankHourlyRates'[Rank], [Rank]
     
    and it works.
sjpaq's avatar
sjpaq
Helper I
2 years ago

No responses, I think I have figured this out.

I changed the DAX formula to the following:

ExtendedCost =
    SUMX(ResponseCosts, ResponseCosts[Hours] *
            LOOKUPVALUE ('RankHourlyRates'[Hourly Rate],
            'RankHourlyRates'[Rank], [Rank]
 
and it works.