Forum Discussion
Table visual does not update accordingly
This is happening because [Reviews out of Date] is a measure, which means it doesn't have a row context to cross filter the office/names table. Notice that you can't use Reviews out of Date as a slicer because it is a measure. So the only thing that filters the Offce/Names table is "Manchester".
The way I can think to fix this would be to add a "Reviews out of Date Status" calculated column/table, which will require you to rework the table structure and/or the calculations that Reviews out of Date is based on. Once you have a "Reviews out of Date Status" column/table (i.e. for every name you would have a status of "Current" or "Out of Date"), you can use that in the bar chart as the value (to get the count), legend (to enable interaction with the table), and visual-level filter (to only show those with the out of date status).
Anonymous
Check this expression.
Number of Reviews Out of Date = CALCULATE(COUNTA(Skills[ReviewsDue Date Mark]),Skills[ReviewsDue Date Mark]="Out of Date")
If you have any question, feel free to let me know.
A simple way to do this is to make a visual level filter on your text block where 'reviews out of date' is greater then 0 (zero).
If you filter by clicking on a bar in your table it will only show the six persons with a review out of date. Good luck!
"Please click the Accept as Solution if this resolves your issue; if it did not resolve your issue, provide more information on what happened instead.".