Forum Discussion

cfahner's avatar
cfahner
Frequent Visitor
2 years ago
Solved

SumX Filter with multiple selected slicer values

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],...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    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]))

amitchandak's avatar
amitchandak
Super User
2 years ago

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]))