Forum Discussion

jimpatel's avatar
jimpatel
Post 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
Community Champion
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"
)
jimpatel's avatar
jimpatel
Post Patron
3 years ago

Amazing work. Thanks a lot. This helping me to remove the barrier.

 

Thanks again