Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
finno14
Helper I
Helper I

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 ?

 

finno14_0-1652946867933.png

 

 

 

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

1 ACCEPTED SOLUTION

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

  

View solution in original post

4 REPLIES 4
finno14
Helper I
Helper I

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

 

finno14_0-1652965571567.png

 

 

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

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

  

Of course it is! Mind blank! Thank you!! @NickolajJessen 

amitchandak
Super User
Super User

@finno14 , 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))

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.