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

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

HI stoss 

For the row context of the visual has changed, the [New Measure] has been changed too.

So for your case, just add a new measure

Count MessageTraceld 
= VAR _TABLE=ADDCOLUMNS(SUMMARIZE(message,message[_time],message[MessageTraceId]),"_A",[New Measure]) RETURN
COUNTAX(FILTER(_TABLE,[_A]>=1),[MessageTraceId])

and remove the visual level filter of this table visual.

 

Regards,

Lin