Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have 2 bar charts,1 showing sales and other showing revenue for different countries.
I have filters year, Product and category.
I want First Chart (sales) should always display data for 2019 (current year) . It should be filtered by Product only and no impact by Year and Category. 2nd chart should be filtered by all the 3 filters.
I tried with : Sum({1<[Year]={'2019'},[Year]=,[Category]=>}[Sales])
It is not working as expected. First chart is showing data for Current year but not getting filtered by Product.
Thanks in advance.
Try by removing the 1
Sum({1<[Year]={'2019'},[Year]=,[Category]=>}[Sales])
Thanks @sunny_talwar . I was unwell, so couldn't revert.
One more thing - In above expression, instead of sales, I am trying to use sum (sales) /Sum(revenue).
But it is showing some expression error:
Sum({<[Year]={'2019'},[Year]=,[Category]=>}[sum (sales) /Sum(revenue))
Could you please help to correct.
Regards,
OK
Hi Kulkarni,
The Expression You have is using a sum function with Set Analysis already so no need of using an nested aggregation.
Use the Following Expression:
Sum({<[Year]={'2019'},[Year]=,[Category]=>}sales) /Sum({<[Year]={'2019'},[Year]=,[Category]=>}revenue)