Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Check several rows with same ID

Hi folks,   I am quite new to PowerBI and currently wokring on the following topic:   I do have messages and message_threads, both are in one table. Messages can be either OUTBOUND (sent by compa...
  • daXtreme's avatar
    daXtreme
    4 years ago

    tamerj1 

     

    There's no need to use IF here since ISEMPTY is already a logical function. This is the same:

    NOT ISEMPTY(
    FILTER(
        CALCULATETABLE(
            T,
            ALLEXCEPT(
                T,
                T[thread-id]
            )
        ),
        T[message-type] = "INBOUND"
    )
)
tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi Anonymous 

please try

=
IF (
    ISEMPTY (
        FILTER (
            CALCULATETABLE ( TableName, ALLEXCEPT ( TableName, TableName[thread-id] ) ),
            TableName[message-type] = "INBOUND"
        )
    ),
    FALSE,
    TRUE
)
  • daXtreme's avatar
    daXtreme
    Solution Sage
    4 years ago

    tamerj1 

     

    There's no need to use IF here since ISEMPTY is already a logical function. This is the same:

    NOT ISEMPTY(
    FILTER(
        CALCULATETABLE(
            T,
            ALLEXCEPT(
                T,
                T[thread-id]
            )
        ),
        T[message-type] = "INBOUND"
    )
)
    • tamerj1's avatar
      tamerj1
      Community Champion
      4 years ago

      daXtreme 

      You are 100% correct. Thank you