Forum Discussion
Dynamic Measure based on selected filters/slicers
Community Championand your filter, is it all in the same table?
Yes, the filter is from a field on the table Performance
At the moment there's a date table sitting as the bridge between Performance and LY Performance and that's where the measure is
- vanessafvg
right ok thats make more sense now, and the filter which table is it sitting in?
is the direction of the relationship single or both?
Performance is mapped to TYWeek and LY Performance mapped to LYWeek
The relationshsips are both 'Both'. The filter is in the table Performance
- vanessafvg
ok just a few thoughts here
-worker is being applied to performance but not last years performance because there is no link there the link is on date not worker.
Is the structure and granularity of ly data the same as this years data? if so why not combine it?
basically in order to filter both performance and last years performance to worker you need a relationship there. because you already have a relationship on the date on date it might be better to combine the two tables and then do a calculation in dax to get py performance
Well that opens the can of worms that is how I'm dealing with this YoY comparison....
I couldn't work out how to do it properly in DAX so I did an ugly fudge of basically duplicating the Performance table and linking the TY week field to the LY week field.
If you could advise on the 'correct' way to compare Week 201617-01 to Week 201718-01 then I'd be very happy. I think a problem is that the data is summarised at a weekly level rather than daily? Like I said: I'm simple and new to this!