employees based on date to give me the count of Annual leaves

[Anonymous]

Dear All,

I am busy with a Dax that group the employees based on date to give me the count of Annual leaves 

SUMMARIZE(TA_Timerecord;(COUNTX( FILTER( RELATEDTABLE(TA_Timerecord); TA_Timerecord[Allowancekind] = "PKB 10");TA_Timerecord[Employee]);TA_Timerecord[Date]))

Can any one help please?

Kind regards,

Ezz

[amitchandak · Accepted solution]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example. Can you share sample data and sample output.

Appreciate your Kudos.

[Anonymous]

@amitchandak Yes Sure
I have three coloumn Employee, Date and Allowancekind,
I have to report the count of days(date) for each employee based on the value of Allowancekind.

[v-deddai1-msft]

Hi @Anonymous ,

Would you please inform us more detailed information( your sample data and  expected output (by OneDrive for Business)) if possible? Then we will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.

Best Regards,

Dedmon Dai