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"
    )
)
daXtreme's avatar
daXtreme
Icon for Solution Sage rankSolution Sage
4 years ago
// Let the table be T.

[# Active Threads] =
CALCULATE(
    DISTINCTCOUNT( T[thread-id] ),
    DISTINCT( T[thread-id] ),
    T[message-type] = "inbound",
    REMOVEFILTERS( T )
)