Forum Discussion

Mat42's avatar
Mat42
Resolver I
5 years ago
Solved

Fixed Chart Comparator

This feels like it should be simple, but for the life of me I can't work out how to do it. Let's say I have a very simple table containing the following entries:   Name Sales Figures Yearly T...
  • lbendlin's avatar
    lbendlin
    5 years ago

    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.

     

     

     

     

     

     

     

     

Mat42's avatar
Mat42
Resolver I
5 years ago

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?

lbendlin's avatar
lbendlin
Super User
5 years ago

Change the relationship to 1:M from Names to Data. Then change the measure to compute the company average properly as I mentioned initially.

  • Mat42's avatar
    Mat42
    Resolver I
    5 years ago

    lbendlin Perfect!

     

    Thanks a lot.