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"
)
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"
)
  • jimpatel's avatar
    jimpatel
    Post 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
      Community 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
        Post 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