Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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))
User | Count |
---|---|
141 | |
70 | |
70 | |
53 | |
53 |
User | Count |
---|---|
208 | |
95 | |
64 | |
61 | |
57 |