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 

Sorry I did not understand. What do you mean by "if part number same"?

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

Thanks for your reply.

In the above example, 123 have one "True" in the "Status" and therefore "Status 2" is true for 123.
23 does not have any true at all, therefore status 2 will be false for that
43 have two true and status 2 will be true for that

Hope this helps

Note: Part numbers wont be in the ascending or descending orders and it will be clustered around the rows.

Thanks a lot

  • 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"
)