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.
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).
Thanks for the clarification.
I have created a new calculated column
ReviewsDue Date Mark = IF(Skills[Review Age]>90,"Out of Date","Recent")
Trying now to get the number of Reviews Out Of Date with the CALCULATE but surely I am missing the point with this function.
This renders an error that I cannot understand.
Number of Reviews Out of Date = CALCULATE(COUNT(Skills[ReviewsDue Date Mark],ALL(Skills[ReviewsDue Date Mark]="Out of Date")))
Too many arguments were passed to the COUNT function. The maximum argument count for the function is 1.
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.