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"
)
jimpatel's avatar
jimpatel
Icon for Post Patron rankPost Patron
3 years ago

Hi,

 

Sorry for reopening the post.

 

What do i need to change in the formula if i need to do the following condition please?

 

Note: All columns in the same table. The solution i am looking for is  "Status 2" column please

 

Issue is, this is from same table and all i need to compare is if "Part number" same , if yes look for "Status" and if any of the status is "True" for those part numbers then "Status 2" expected to be "true" if not "False"

 

Thanks a lot 

 

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