ruthhacche
Board Regular
- Joined
- Sep 22, 2017
- Messages
- 84
I want to do a waterfall chart showing the movement in the number of products (selling more than £100) from last year to this year. So I need the number of products sold in two fiscal years in one visual which is filtered for just the current year.
I have a number of products measure
Number of Products =
CALCULATE (
DISTINCTCOUNT ( 'Order Lines'[Item Short Name] ),
FILTER ( 'Order Lines', [Sale] > 100 )
)
When the current fiscal year is selected this measure returns the number of product sold in the current fiscal year (YAY). It would be lovely if I could just change [Sale] to [Sale LY] but clearly it is not as simple as this. So please point me in the right direction to get Number of Products LY. I am sure it is simple for some of the brains on here.
I have a number of products measure
Number of Products =
CALCULATE (
DISTINCTCOUNT ( 'Order Lines'[Item Short Name] ),
FILTER ( 'Order Lines', [Sale] > 100 )
)
When the current fiscal year is selected this measure returns the number of product sold in the current fiscal year (YAY). It would be lovely if I could just change [Sale] to [Sale LY] but clearly it is not as simple as this. So please point me in the right direction to get Number of Products LY. I am sure it is simple for some of the brains on here.