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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

PBI5851 , You can create a measure like this and try

 

sumx(table, Switch(true(), [Rep] = "Steve" , 8 , [Rep] = "Kate" , [Rep] = "Angie" , 10 , 5))