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"
    )
)
lulubrinki1's avatar
lulubrinki1
New Member
4 years ago

Thank a lot daXtreme tamerj1 ,

I have to correct my initial table I posted. 

factMessages

Message-idThread-IDMessageAttrKey
111
2 2
323
424

 

dimMessageAttributes

MessageAttrKeyType...
1OUTBOUND 
2OUTBOUND 
3INBOUND 
4INBOUND