Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to Calculate specific values in a filter

Good Morning, 

Apologies if this has been answered. 

 

I am looking to only calculate values that I specifically highlight within my filter. Currently the below code will calculate between 15th-19th how do it make so it only calculates the 15th & 19th ?

 

 

 

 

Bank_holiday_After = 

var _max1 = MAXX(ALLSELECTED(First_Period_Comparison),First_Period_Comparison[Date])

var Help=  MINx(ALLSELECTED(First_Period_Comparison),First_Period_Comparison[Date])


return 
CALCULATE([Incidents_Fri_Mon],FILTER('Alex Date Period Flow','Alex Date Period Flow'[Date]>=  Help &&'Alex Date Period Flow'[Date]<= _max1))

 

 Kind regards,

AF

Need Help
  • NickolajJessen's avatar
    NickolajJessen
    4 years ago

    Isn't it just the ">=" and "<=" that needs to be replaces with just "="
    And "&&" with "||"

      

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , for the table in slicer, need to be an independent table

     

    example

    //Date1 is independent Date table
    new measure =
    var _max = maxx(allselected(Date1),Date1[Date])
    var _min = minx(allselected(Date1),Date1[Date])
    return
    calculate( sum(Table[Value]), filter('Table', 'Table'[Date] >=_min && 'Table'[Date] <=_max))

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi amitchandak ,

     

    Thanks for this, I have inputted as per below but im still encountering the same issue. Ideally the Bank_holiday_after total would =  2052 as opposed to the current 7437

     

     

     

    Bank_holiday_After = 

var _max = MAXX(ALLSELECTED(First_Period_Comparison),First_Period_Comparison[Date]) -- Comparison Date Table

var _min=  MINx(ALLSELECTED(First_Period_Comparison),First_Period_Comparison[Date]) -- Comparison Date Table


return 
CALCULATE([Incidents_Fri_Mon],FILTER('Alex Date Period Flow','Alex Date Period Flow'[Date]>=  _min &&'Alex Date Period Flow'[Date]<= _max)) -- Main Date Table

     

    Thank you for your help,

     

    AF

    • NickolajJessen's avatar
      NickolajJessen
      Solution Sage
      4 years ago

      Isn't it just the ">=" and "<=" that needs to be replaces with just "="
      And "&&" with "||"