Forum Discussion
Using a Slicer to Indirectly Filter a Line Chart
Ok, so the issue here is because your data model is different to what you described in your first post. In there you only mentioned a single table, so I shared code that would work with a single table, but because you have a separate calendar table and columns from that are on the axis of your graph you should create a measure like the following and use that to filter your slicer and graph
FTE (all time) = CALCULATE( SUM( 'Master Filtered'[FTE] ) , ALL('Calendar'))
d_gosbell That did it! Thank you.
I'm not usre I understand how this works. Could you explain to me what this measure is doing? How does it filter out the projects that have no FTE > 0?
Anonymous wrote:
I'm not usre I understand how this works. Could you explain to me what this measure is doing? How does it filter out the projects that have no FTE > 0?
It's basically calculating a grand total of FTE over all dates. When you calculate this on a line graph that has a line per project it will calculate the grand total per project.
If you create a new test page in your report then create a table visual that has project, date, FTE and the new [FTE (all time)] measure you should be able to see what it's calculating