Removing month filter on YTD calculation

[Raph]

Hello,

Let's say I have a simple model like this : 

I have this measure which calculates sold quantities on a YTD basis : 

Quant. YTD = CALCULATE(SUM(Sales[Quantity]),DATESYTD('Date'[Day])) ... which works fine when there is no month selected on the Month slicer. If I select a month on the slicer, there is of course only one point left one the line chart. So I changed the measure in order to display all months on the line chart even if a month is selected on the slicer : 

Quant. YTD ALL Month = CALCULATE(SUM(Sales[Quantity]),DATESYTD('Date'[Day]), ALL('Date'[Month]))

The problem is : even with this ALL supposed to remove the month filter, there is only one point left in the line chart if the user select a specific month.

Can anyone help me on this?

Thank you.

Raphaël

[Raph]

Nobody?

[Tanushree_Kapse]

Hi @Raph ,

Sorry for the late reply.

I don't think you can do this in a line or a bar chart.

You are using the month column in the axis...and the visual still being interacted with the slicer, clearly filters out the months on the basis of your selections in the slicer, even if you are using a measure with the ALL function in the values field. 

You'll have to remove the interaction between the two.

I hope this helps!

Mark this as a solution if I answered your question. Kudos are always appreciated.

Thanks! 

[Raph]

Please find below a link to the PBIX file : 

https://drive.google.com/file/d/1Qw55fM9d1btmrdCkwBYWK460k7Cswat5/view?usp=sharing

Thank you

Raphaël

[Tanushree_Kapse]

Hi @Raph ,

You can simply remove the interaction of Line chart with the slicer.

Thanks.

[Raph]

Thank you for your answer @Tanushree_Kapse 

Indeed that is how I fixed the problem but I am looking now for a DAX solution. I would like to understand why ALL () is not enough to remove filter applied on month.

Thank you

Raphaël