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.
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.
Many thanks.
It works! I can now get the list of users whose review is out of date just by clicking the graph.
For future reference, and consolidate my knowledge, for the CALCULATE function I need to use the same column reference for both Expression and Filter?
CALCULATE(COUNTA(Skills[ReviewsDue Date Mark]),Skills[ReviewsDue Date Mark]="Out of Date")
Anonymous
The COUNTA function counts the number of cells in a column that are not empty.
The expression wrapped in COUNTA depends on what to count, you don't have to use the same column.