Help with Filtering

[Anonymous]

Hello all, 

I am making a report looking at attended events.

However I am trying to Filter on a specific event, and then show who attened that event, and which other events they have attened. 

The issue is that because im filtering from the same collum as the results i am trying to show, when i filter on Event 1, it shows me who attened, but not the other events they attened. 

Any help is appreciated!

thanks

[Ashish_Mathur]

Hi,

See if my solution here helps - Filter a column of a Pivot Table on a certain condition but also show other items from that column.

[v-rzhou-msft · Accepted solution]

Hi @Anonymous 

You could build a Slicer table by event column and build a measure and use filter field to achieve your goal.

My Sample Table:

Slicer Table:

Table 2 = VALUES('Table'[Event])

Measure:

Measure = 
Var _Sel = SELECTEDVALUE ( 'Table 2'[Event] )
RETURN
CALCULATE (
    MAX ( 'Table'[User] ),
    FILTER (
        ALLSELECTED ( 'Table'[Event] ),
        'Table'[Event] = _Sel
    )
)

 Drag measure into Filter Field and show items when the value is not blank.

When we select Event1 it will show A,C,D and all events they have.

You can download the pbix file from this link: Help with Filtering

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[amitchandak]

@Anonymous , Try a measure like

measure =
var _tab = summarize(filter(allselected(Table), table[user]))
return
calculate([measure], filter(all(Table), Table[user] in _tab))