Filter 2 Visuals where value is in either column.

[Anonymous]

Hello, I have created a dashboard that displays writer workflow counts by both primary and secondary writer. Currently, the dashboard has 2 slicers and if you filter my Primary Document Writer it shows the count of documents for the Primary Document Writer and the count of documents for the writers that are listed as the Secondary Document Writer based on the initial filter. The end users have requested that the filter only show a cound of documents where the writer is listed as the Primary or as Secondary. Below is a screenshot of what I currently have setup. Ideally there is just one filter that will filter both visuals showing the count of documents where the writer is listed as either primary or secondary. I have also included a screenshot of dummy data showing what the correct outcome should be for each visual. 

[MFelix · Accepted solution]

Hi @Anonymous ,

Create a new table with the writers then add the following measures:

Primary document = CALCULATE(COUNTROWS('Table'), 'Table'[Primary Document Writer] in VALUES(Writers[Writer]))

Secondary document = CALCULATE(COUNTROWS('Table'), 'Table'[Secondary Document Writer] in VALUES(Writers[Writer]))

Now use the table with the writers on the axis and the metrics on the values, if you want to have an overal one you can also create the following one:

Total count = [Primary Document] + [Secondary Document]

Now just setup has you need, use the slicer of the writer tables:

PBIX file attach.