sales from calendar start date to user selected date

[newbie9]

Hi

my problem is

I have 2 slicers one is date range slicer(slider) & the other is year & month slicer

I have a requirement like if user is selecting a date in date range slicer it should show sum from calendar start date to user selected date & if the user is selecting year & month slicer then it should calculate the sum from calender start date to last date of year & month that user has selected

the real problem is

if we select year & month it also selects the range in date slicer(slider) so it only calculates for that month

so the ask is 

month year slicer should filter date slicer(slider) but the measure need to be affected

we can't remove interaction between date slicer(slider) with the measure because we also calculate the sum when user select on slider too

[v-binbinyu-msft]

Hi @newbie9 ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[newbie9]

hi @v-binbinyu-msft 

Thanks for your reply

I was able to solve this,

my expectation was my month year slicer shouldn't be bound to any date range, it should calculate sales from start to user selected date

I was able to accomplish by removing relationship between dim date & sales table using crossfilter fun

Now I need a solution for the below one, 

This issue is bugging me for a month

I have also added screenshots 

https://community.fabric.microsoft.com/t5/Desktop/filter-context-is-not-working-in-add-columns/m-p/3...