Forum Discussion

drinko's avatar
drinko
Icon for Helper I rankHelper I
4 years ago

Total for measure doing row level calculation

I am doing a labor report where I identify each employee that works a >= 20 hour shift completed on a certain date.  The Labor tables has Employee ID, Location ID, Timecard Date, Hours, Dollars and m...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

To your visual, drag Region from the second table to the row labels.  Write this measure:

20+Hr Dollars = CALCULATE(sumx(Filter(Values(Labor[Employee ID]),SUM(Labor[Final Hours])>=20),Labor[Dollars]))

If this measure does not work, then share the download link of your PBI file and show the problem very clearly.