Forum Discussion

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

Count is giving difference in visual

Hi ,   I am getting count of active employees difference when i put same measure in visual under category of gender.   actual count is 167 but in table count it is showing 168. but i need 167 cou...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Srikantht , Try like

 

_# Of Active Employees =
Var Maxdate=MAX('EMPLOYEE_SNAPSHOT'[Date])
Var Result=CALCULATE (
COUNT('EMPLOYEE_SNAPSHOT'[Active_Employee_Count]),
filter(allselected( 'EMPLOYEE_SNAPSHOT'),'EMPLOYEE_SNAPSHOT'[Date]=Maxdate))
Return Result

 

or

 

_# Of Active Employees =
Var Maxdate=MAX('EMPLOYEE_SNAPSHOT'[Date])
Var Result=CALCULATE (
COUNT('EMPLOYEE_SNAPSHOT'[Active_Employee_Count]),
filter(allselected( 'EMPLOYEE_SNAPSHOT'),'EMPLOYEE_SNAPSHOT'[Date]=Maxdate))
Return Sumx(values('EMPLOYEE_SNAPSHOT'[Gender]) , Result)

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

Hi amitchandak 

 

Here we have multiple categories like Gender, Age group & mangment level. every category have one visual but measure is same for all. 

here difference is coming if i have measure value 167 in card.  when it comes to category visual like for gender count is 168, for managment level count is 169 & age group count is 167. like that values are coming.

 

I want the output 167 for all the categories. 

 

Can you help in this.

 

Thanks.