Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Table visual does not update accordingly

Hello,   I am creating compiling some visuals for a dashboard that allows for quicker assessment of Skills Reviews status for staff accross 3 different offices.   For such, a measure was created ...
Need Help
  • chrisu's avatar
    chrisu
    10 years ago

    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).  

     

  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    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.

Nhallquist's avatar
Nhallquist
Helper V
10 years ago

I think the reason why your user list isn't updating is because you are using a formula to count all the reviews for an office, and then you are subtracting the completed reviews, then plotting the Difference on the chart.  I think you need to write a DAX expression in the data that determines if a Review is out of date.  Then you can use that Data field to calculate your chart and also to filter your table.

 

Hope this helps.

 

Nate