Forum Discussion
Fixed Chart Comparator
You don't need to include the Company average in your data if you can also compute it on the fly. But if that is not possible then you can still make it work by using a separate measure.
Sales Average := CALCULATE(sum(Performance[Sales Figures]),Performance[Name]="Company Average")Then add the Sales Figures value and the new measure to the Values well.
You don't need to include the Company average in your data if you can also compute it on the fly. But if that is not possible then you can still make it work by using a separate measure.
Sales Average := CALCULATE(sum(Performance[Sales Figures]),Performance[Name]="Company Average")
Then add the Sales Figures value and the new measure to the Values well.
lbendlin, that's brilliant and works as I need it to. Quick related follow-up question:
Because this is part of a larger report I'm slowly building up, I'm adding new sections every day and I now have 2 tables: the simple data table I explained before, and a new table called 'Names' that I've created to only contain (unsurprisingly) staff names. I've joined the Names table to the data table using a one-to-one relationship.
If I follow your instructions, then produce a slicer containing staff names using the original data table, the chart displays correctly. However, if I create a slicer using the new Names table the Sales Average data disappears off the chart.
Is there something that needs changing in the measure?
