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.
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 "||"
@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))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |