Forum Discussion
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...
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 because the messageId "12" contains a row with "external" recipient.
I need to count MessageID with only "internal" value in "recipient" column.
As MessageId "12" is also associated to a row containing "external" value, I have to exclude it even if we have rows with "internal".
stoss solution attached, look at message table and page 4, there is other stuff in attached file, ignore that.