Forum Discussion
Solved
Filtering with fields that have multiple selections - What are people doing?
My data source that I use for a lot of my reporting allows the end users to select multiple options for various fields. For example there is a client impacted field. We have a list of important ...
Hi AmberJane ,
It is caused by the filter context, you can create a measure as below to get the count of incidents which fulfill the requirement:
# of Incidents = VAR _selcausedby = SELECTEDVALUE ( 'Caused by'[Caused by] ) RETURN CALCULATE ( COUNT ( 'Table'[ID] ), FILTER ( 'Table', SEARCH ( _selcausedby, 'Table'[Caused by], 1, 0 ) > 0 ) )Best Regards
Hi AmberJane ,
I created a sample pbix file(see the attachment), please check if that is what you want.
Best Regards
This worked with the table I have but its not working with other reports. For example I have a card that just shows the # of incidents and I cannot add that flag to the filter for the card.
Hi AmberJane ,
It is caused by the filter context, you can create a measure as below to get the count of incidents which fulfill the requirement:
# of Incidents = VAR _selcausedby = SELECTEDVALUE ( 'Caused by'[Caused by] ) RETURN CALCULATE ( COUNT ( 'Table'[ID] ), FILTER ( 'Table', SEARCH ( _selcausedby, 'Table'[Caused by], 1, 0 ) > 0 ) )Best Regards