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

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
    Community Champion
    3 years ago

    jimpatel 

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

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

        jimpatel 

        Please try

        Trur/False =
IF (
    ISEMPTY (
        CALCULATETABLE (
            'Table',
            ALLEXCEPT ( 'Table', 'Table'[Part Number] ),
            Table2[True/False] = "TRUE"
        )
    ),
    "FALSE",
    "TRUE"
)