I have created a slicer that allows the user to switch between 4 departments and filter the visuals accordingly. I am trying to apply this switch to a productivity calculation for each department. "Last_Month" is a measure that will be displayed on a card, but with the code posted below it is displaying 0 as the result. Does anyone have any suggestions as to how to fix this?
Please show me the relationship among these tables.
"Department1", "MeasureSwitch", "Daily_Hours_Clean", "Date"
Try the single formula in your table to see if it works