Forum Discussion
sohailstsindia
8 years agoHelper I
CALULATE COUNT AND PERCENTAGE
EMP DATE PROJ A 1/1/2018 P295 A 1/2/2018 P295 A 1/3/2018 P295 A 1/4/2018 P295 A 1/5/2018 P296 A 1/6/2018 P296 A 1/7/2018 P295 B 1/1/2018 P296 B 1/2/20...
- 8 years ago
May be a MEASURE like
Percentage = COUNT ( TableName[DATE] ) / CALCULATE ( COUNT ( TableName[DATE] ), ALLEXCEPT ( TableName, TableName[EMP] ) ) - 8 years ago
Hi sohailstsindia,
In your scenario, you are using a date slicer to filter your data. Right?
If so, to achieve your requirement, you can create several measures with expression like below:
Count days based on Emp and Proj:
Count Days = CALCULATE ( COUNT ( 'Table'[DATE] ), FILTER ( ALLSELECTED ( 'Table' ), 'Table'[EMP] = MAX ( 'Table'[EMP] ) && 'Table'[PROJ] = MAX ( 'Table'[PROJ] ) ) )Count total days based on Emp.
Total Days = CALCULATE ( COUNT ( 'Table'[DATE] ), FILTER ( ALLSELECTED ( 'Table' ), 'Table'[EMP] = MAX ( 'Table'[EMP] ) ) )Then the percentage will be:
Percentage = [Count Days]/[Total Days]
For sure, you can combine above measures into one.
Thanks,
Xi Jin.
v-xjiin-msft
8 years agoSolution Sage
Hi sohailstsindia,
In your scenario, you are using a date slicer to filter your data. Right?
If so, to achieve your requirement, you can create several measures with expression like below:
Count days based on Emp and Proj:
Count Days =
CALCULATE (
COUNT ( 'Table'[DATE] ),
FILTER (
ALLSELECTED ( 'Table' ),
'Table'[EMP] = MAX ( 'Table'[EMP] )
&& 'Table'[PROJ] = MAX ( 'Table'[PROJ] )
)
)Count total days based on Emp.
Total Days =
CALCULATE (
COUNT ( 'Table'[DATE] ),
FILTER ( ALLSELECTED ( 'Table' ), 'Table'[EMP] = MAX ( 'Table'[EMP] ) )
)Then the percentage will be:
Percentage = [Count Days]/[Total Days]
For sure, you can combine above measures into one.
Thanks,
Xi Jin.