Forum Discussion

jimpatel's avatar
jimpatel
Icon for Post Patron rankPost Patron
3 years ago
Solved

DAX formula

Hi.   Thanks for looking at my post.   I am having 2 tables named as table 1 and table 2 but not related to each other.   What i am looking for DAX formula for "Table 1" column B as shown below...
Help
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi jimpatel 

    is the true/false column from table 2 a text or boolean data type?

    Trur/False =
IF (
    ISEMPTY (
        FILTER (
            Table2,
            Table2[Part Number] = Table1[Part Number]
                && Table2[True/False] = "TRUE"
        )
    ),
    "FALSE",
    "TRUE"
)
  • tamerj1's avatar
    tamerj1
    3 years ago

    jimpatel 

    Please try

    Status2 =
IF (
    ISEMPTY (
        FILTER (
            CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[Part Number] ) ),
            'Table'[Status] = "TRUE"
        )
    ),
    "FALSE",
    "TRUE"
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

jimpatel 

Please try

Trur/False =
IF (
    ISEMPTY (
        CALCULATETABLE (
            'Table',
            ALLEXCEPT ( 'Table', 'Table'[Part Number] ),
            Table2[True/False] = "TRUE"
        )
    ),
    "FALSE",
    "TRUE"
)
jimpatel's avatar
jimpatel
Icon for Post Patron rankPost Patron
3 years ago

Thanks for your reply,

 

But i getting "Status 2" same as "Status" column for above formula

 

Like this

 

 

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    jimpatel 

    Please try

    Status2 =
IF (
    ISEMPTY (
        FILTER (
            CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[Part Number] ) ),
            'Table'[Status] = "TRUE"
        )
    ),
    "FALSE",
    "TRUE"
)
    • jimpatel's avatar
      jimpatel
      Icon for Post Patron rankPost Patron
      3 years ago

      This is really unbelievable work. Thanks a lot for your time. Can you please point me where i can learn these kind of formulas please?

       

      Thanks a lot again