Forum Discussion

PBI5851's avatar
PBI5851
Icon for Helper V rankHelper V
5 years ago

Help on Per Day and Month Calculation

Hello folks ,  Please can you help me resolve the monthly count. The numbers are correct when i display the day, but if i remove the day, the monthly counts are incorrect. For the Data Model, the da...
Need Help
sevenhills's avatar
sevenhills
Icon for Super User rankSuper User
5 years ago

If it is me, I would have done like this....

 

a) Add calculated column in the transform data  

 #"Added Conditional Column" = Table.AddColumn(#"Changed Type", "Custom Goal", each if [Rep] = "Steve" then 8 else if [Rep] = "Kate" then 9 else if [Rep] = "Angie" then 10 else 5),

 

gives something like 

 

b) Dax Measure  

Active Goal Count = 
var tempTable1 = SUMMARIZE('Your Table', 'Your Table'[Rep], 'Your Table'[Custom Goal], 'Your Table'[Job_Start])

Return sumx(tempTable1, 'Your Table'[Custom Goal])

 

Output :