Forum Discussion

richard_jackson's avatar
richard_jackson
Frequent Visitor
3 years ago
Solved

One filter for Week and Past Four Weeks

Hi there!   I have a Finance dashboard and have been asked to add a weekly filter. This filter must be used to reduce certain charts to using that week only, and other charts to be using data from ...
Need Help
Tutorial Requests
  • richard_jackson's avatar
    richard_jackson
    3 years ago

    This has now been resolved without using independent date tables:

     

    NewMeasure_FourWeekValues = 
    var _max = MAXX(ALLSELECTED('DateTable'),'DateTable'[Week])
    var _min = _max - 3
RETURN
    CALCULATE(SUM(ValueTable[Value]),FILTER(ALL('DateTable'), 'DateTable'[Week] >= _min && 'DateTable'[Week] <= _max))

     

     

     Thanks for the direction amitchandak & Anonymous !


    Rich

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi richard_jackson ,

 

Create an independent week slicer table and create measures like below:

measure1 = IF(selectedvalue('table'[week]) = selectedvalue(slicer[week]),1,0)

measure2 = IF(selectedvalue('table'[week]) > selectedvalue(slicer[week])-4,1,0)

Put these two measures into corresponding visual filter and set value =1.

 

Best Regards,

Jay

  • richard_jackson's avatar
    richard_jackson
    Frequent Visitor
    3 years ago

    Hi there - thanks, I've been on holiday this week so I'll look into this now!

     

    I'll let you know how I get on!

     

    Rich