Forum Discussion
Dynamic Measure based on selected filters/slicers
Community Championfirstly i would do a divide in dax as
YoY Growth All Rev = divide([TY All Rev],[LY All Rev])
(not sure it will make a diff but worth a try)
what is the -1 for?
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
- vanessafvg
and 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?