topic Re: Removing month filter on YTD calculation in DAX Commands and Tips

Removing month filter on YTD calculation

Raph — Wed, 04 Aug 2021 08:14:55 GMT

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

Re: Removing month filter on YTD calculation

Tanushree_Kapse — Wed, 04 Aug 2021 10:11:42 GMT

Hi Raph ,

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

Thanks.

Re: Removing month filter on YTD calculation

Raph — Wed, 04 Aug 2021 10:51:43 GMT

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

Re: Removing month filter on YTD calculation

Raph — Thu, 05 Aug 2021 07:47:54 GMT

Please find below a link to the PBIX file :

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

Thank you

Raphaël

Re: Removing month filter on YTD calculation

Raph — Mon, 09 Aug 2021 12:41:05 GMT

Nobody?

Re: Removing month filter on YTD calculation

Tanushree_Kapse — Mon, 09 Aug 2021 14:57:01 GMT

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!