Forum Discussion

Zakhamido's avatar
Zakhamido
Frequent Visitor
2 years ago
Solved

Matching Values from 2 tables

I have a problem and I am seeking for help, I have an issue with a DAX formula. First of all let me explain my requirment, I have 2 tables one in direct query and the other in import mode  The firs...
  • Fowmy's avatar
    Fowmy
    2 years ago

    Zakhamido 

    Please try this meaure:

    MatchedAccounts =
SUMX (
    ADDCOLUMNS (
        TIBCOINCIDENT_UPDATED,
        "__DCount",
            VAR CurrentSubName = TIBCOINCIDENT_UPDATED[SUB_NAME]
            VAR CurrentStatus = TIBCOINCIDENT_UPDATED[STATUS]
            VAR CurrentOutageTime = TIBCOINCIDENT_UPDATED[Outage_Time_UAE]
            VAR CurrentTime =
                NOW ()
            RETURN
                IF (
                    CurrentStatus = "Un-Planned Pending"
                        && CurrentOutageTime > CurrentTime - 24,
                    CALCULATE (
                        DISTINCTCOUNT ( 'Medical Case'[Per Src Id] ),
                        'Medical Case'[Substation] = CurrentSubName
                    )
                ) + 0
    ),
    [__DCount]
)
Zakhamido's avatar
Zakhamido
Frequent Visitor
2 years ago

Thanks a lot