Forum Discussion

stoss's avatar
stoss
Frequent Visitor
6 years ago
Solved

Filter with 2 columns

Hello,   I would like to make a filter in one "recipient" column and filter also the identical values present in "MessageTracId" column.   If I make a filter in "recipient" column with => Not Con...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi stoss 

    Just adjust the formula as below:

    New Measure = VAR __rec = SELECTEDVALUE ( message[recipient] )
VAR __id = SELECTEDVALUE(message[MessageTraceId]) 
VAR __cc = CALCULATE( COUNTROWS( message ), ALLSELECTED( message[recipient] ), message[MessageTraceId] = __id )
VAR __cx =  CALCULATE(COUNTROWS( message ),ALL(message),message[MessageTraceId]=__id)
RETURN IF ( __cc = __cx, __cx, 0 )

    Then use it as visula level filter:

     

    Regards,

    Lin

parry2k's avatar
parry2k
Super User
6 years ago

stoss that's not good. share sample data in pbix file and I will take a look. I probably missed something and doesn't have full picture on how your data looks like.

 

Removing sensitive information before sharing.