Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Solved! Go to Solution.
Isn't it just the ">=" and "<=" that needs to be replaces with just "="
And "&&" with "||"
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
Isn't it just the ">=" and "<=" that needs to be replaces with just "="
And "&&" with "||"
@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))
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!