Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Drillthrough Using Slicers to Use Less Than

Hi,

 

I have a page with seven slicers. The seventh slicer being a single select month.

 

I have a drillthrough to another page that uses all the seven slicer values; this gives a month view.

 

I would like a drillthrough to another page but would like to view all items in the year upto and including the month selected in the month slicer.

 

Can this be done?

 

Regards

Mark

Need Help

7 Replies

  • themistoklis's avatar
    themistoklis
    Community Champion
    7 years ago

    Anonymous

     

     

    Please see following DAX formula:

    Values_upto = CALCULATE(SUM(Sheet1[Values]),FILTER(ALLEXCEPT(Sheet1, Sheet1[Year]), Sheet1[Month] <= SELECTEDVALUE(Sheet1[Month])))

    This requires a month to be selected on the slicer.

     

    Workspace is also available on this link

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi themistoklis,

       

      I need to keep all the slicers on for the drillthrough, except the monthly slicer, but it is still active.

       

      Regards

      Mark

      • themistoklis's avatar
        themistoklis
        Community Champion
        7 years ago

        Anonymous

         

        Can you please explain further.

         

        All other slicers will be active and the month one will be used as a slicer to calculate up to the selected value