Forum Discussion
Dynamic Measure based on selected filters/slicers
I've updated it to:
YoY Growth All Rev = DIVIDE([TY All Rev],[LY All Rev],0)-1
and it behaves the same as before
The -1 is to give me the true growth figure (e.g.; if LY=50 and TY=100 I want that to show the growth as 100% rather than the 200% it would show without the -1
Community Championand your filter, is it all in the same table?
- vanessafvg
can you do a few screen shots maybe? and also of your relationships if its more than one 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