Lookup values and create measure

[topazz11]

I'd like to create a measure that calculate value based on lookup table.

here is the sample date file.

pbix file 

Any guidance is appreciated.

Thank you!

[ebeery · Accepted solution]

HI @topazz11 , something like this might work.

NewMeasure =
VAR _SumHours =
    SUM ( 'DataTable'[Hours] )
VAR _TotalHours =
    CALCULATE ( SUM ( 'DataTable'[Hours] ), ALL () )
VAR _PerctGTTotalHours =
    DIVIDE ( _SumHours, _TotalHours )
VAR _SelectedCombined =
    SELECTEDVALUE ( 'DataTable'[Combined] )
VAR _Amt =
    LOOKUPVALUE ( LokupTable[Amt], LokupTable[Combined], _SelectedCombined )
VAR _Result = _PerctGTTotalHours * _Amt
RETURN
    _Result