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 Contains "Test1"
All the rows with MessageTracId "12" should be filtered.
| Source.Name | _time | sender | recipient | MessageTraceId |
| 1119_o365.csv | 30/11/2019 | Bob | Test1 | 12 |
| 1119_o365.csv | 30/11/2019 | Bob | Test2 | 12 |
| 1119_o365.csv | 30/11/2019 | Bob | Test3 | 12 |
| 1119_o365.csv | 30/11/2019 | Bob | Test4 | 12 |
| 1119_o365.csv | 30/11/2019 | Bob | Test5 | 13 |
| 1119_o365.csv | 30/11/2019 | Bob | Test6 | 13 |
| 1119_o365.csv | 30/11/2019 | Bob | Test7 | 13 |
Thank you very much for your help.
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
15 Replies
Thank for you answer, I will explain you my need.
In the below example, i want to count how many messages Bob sent to internal recipient ONLY.
_time sender recipient MessageTraceId 30/11/2019 Bob internal 12 30/11/2019 Bob external 12 30/11/2019 Bob internal 13 30/11/2019 Bob internal 13
So if I make a filter with "internal", I will see 2 messages ID (12 & 13), but I want to count just when there are only "internal" recipients.The result should be :
_time sender recipient MessageTraceId 30/11/2019 Bob internal 13 30/11/2019 Bob internal 13
