Forum Discussion

Matt_Mohawk's avatar
Matt_Mohawk
Icon for Helper II rankHelper II
3 years ago

Count Jobs within Dates Selected

Hi,   I have a list of jobs that have entered dates. I have a date table connected to it as well. The date table is connected to the add-in called ChicletSlicer. When I select the year and the mont...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Very confused.  What do you want the answe to be?  If you want the answer to be 126, then write this measure

Jobs = distinctcount(Data[Job number])

Total = SUMX(VALUES(Calendar[Month name]),[Jobs])

Ensure that you slicers for Year and Month name are from the Calendar Table.