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
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 Thank you for you help. Looks better now
As there is "MessageTraceId" present in the table, I can't count per month on one line.
When I remove "MessageTraceId", the table becomes empty.
I would like a table like that :
2019 December 3
Many thanks again v-lili6-msft and parry2k for you help.
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
It works, thank you very much v-lili6-msft and parry2k