Forum Discussion

matthewhaggett's avatar
matthewhaggett
Regular Visitor
7 years ago
Solved

Lookup based on 2 criteria

Hello   I have a problem that I am trying to solve and cannot get it sorted currently   I have a table of data from Azure Devops which includes history for every item in the system.  This data ha...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    try this measure:

    Measure = 
IF ( HASONEVALUE(Table1[Info]),
CALCULATE(
    VALUES( Table1[Info]),
    CALCULATETABLE(
        Table1,
        ALLSELECTED(Table1[Date])
    )
)
)

Anonymous's avatar
Anonymous
Not applicable
7 years ago

try this measure:

Measure = 
IF ( HASONEVALUE(Table1[Info]),
CALCULATE(
    VALUES( Table1[Info]),
    CALCULATETABLE(
        Table1,
        ALLSELECTED(Table1[Date])
    )
)
)