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! It's time to submit your entry. Live now!
I currently have it working where if one Week Ending Date is selected the measure calculates without issues
Mechanic Cost Breakdown = IF(HASONEFILTER('Electronic Timesheets'[Name]),[Measure 2],SUMX(filter('Time','Time'[Week Ending date ]=SELECTEDVALUE('Week Ending Dates'[WeekEnding])),[Measure 2]))
What I want to do is have the same measure calculate but have the ability to select multiple week ending dates, I have researched some and attempted to do the following but results in an error
test = CONCATENATEX(VALUES('Week Ending Dates'[WeekEnding]),'Week Ending Dates'[WeekEnding],",")
Mechanic Cost Breakdown =
IF(HASONEFILTER('Electronic Timesheets'[Name]),[Measure 2],SUMX(filter('Time',[test] IN VALUES('Time'[Week Ending date ])),[Measure 2]))
Solved! Go to Solution.
@cfahner , Try like
Mechanic Cost Breakdown = IF(HASONEFILTER('Electronic Timesheets'[Name]),[Measure 2],SUMX(filter('Time','Time'[Week Ending date ] in values('Week Ending Dates'[WeekEnding])),[Measure 2]))
@cfahner , Try like
Mechanic Cost Breakdown = IF(HASONEFILTER('Electronic Timesheets'[Name]),[Measure 2],SUMX(filter('Time','Time'[Week Ending date ] in values('Week Ending Dates'[WeekEnding])),[Measure 2]))
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 60 | |
| 47 | |
| 39 | |
| 24 | |
| 23 |
| User | Count |
|---|---|
| 144 | |
| 106 | |
| 63 | |
| 38 | |
| 31 |