Please help me with the set expression and filter condition problem.

[Solomoons]

Hi all,

When I am developing a monthly report App, I want to draw a combo chart about the 'Order intake' comparison between FY23 and FY22.

But I want the chart doesn't change when I use the 'Fyear' filter panel (which means the order intake information about FY23 and FY22 is always shown in the chart even I only choose 'FY23' or other fiscal year in the filter panel) but the chart measure changes when I use other filter panels (like 'Country', 'Business Segment'....). Could you please help me with the set expression of the combo chart or other methods to achieve this goal? 

I have tried the set expression like Sum({$<L3={'Product A'}>*1<Fyear={'2023'}>}[Order Intake]), but it doesn't work in the way I wanted it to.  Any reply would be appreciated! Thank you!

And for your reference:

The comparison chart and the two measures expression of the chart are set like below now:

Measure 1(the bar):

Measure 2 (the line):

And the filter panels are:

[sidhiq91]

@Solomoons  If you do not want the expression to change based on the filter selection. Please see the expression below:

sum({<L3={'Product A'}, Fyear={"2023"}, Country = , [Business Segment] = ,Month = >}[Order Intake])

If this resolves your issue, please like and accept it as a solution.

[Solomoons]

Hello @sidhiq91 , thank you so much for your reply.  But I want the expression to change only according to the filter except for the 'Fyear'. Could you help me with that?

[sidhiq91]

@Solomoons In that case the expression that you have written above should work.

sum({<L3={'Product A'}, Fyear={'2023'}>}[Order Intake])

Let me know if there is any issue that you are still facing.