Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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))
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
87 | |
66 | |
51 | |
45 |
User | Count |
---|---|
215 | |
90 | |
83 | |
66 | |
58 |