Creating a measure to calculate as per logic..

[Anonymous]

Hello,

want to creating a measure if actual login of an emp > 48 hrs then its counts. how many emp for that supervisor as per result table..

Thanks in advance.....

EMP ID	Supervisor ID	Date	Week	Actual Login (Logn-Break)
1	1234	26-Jun-22	26	08:05:00
1	1234	28-Jun-22	26	08:01:00
1	1234	29-Jun-22	26	08:08:00
1	1234	30-Jun-22	26	08:15:00
1	1234	01-Jul-22	26	08:44:00
1	1234	02-Jul-22	26	08:05:00
2	1234	26-Jun-22	26	08:21:00
2	1234	27-Jun-22	26	08:20:00
2	1234	28-Jun-22	26	08:25:00
2	1234	30-Jun-22	26	08:06:00
2	1234	01-Jul-22	26	08:25:00
2	1234	02-Jul-22	26	08:21:00
3	1234	27-Jun-22	26	08:17:00
3	1234	28-Jun-22	26	08:10:00
3	1234	29-Jun-22	26	08:12:00
3	1234	30-Jun-22	26	08:15:00
3	1234	01-Jul-22	26	08:20:00

Result table

If time greater then 48 hrs then its counts
EMP ID	Supervisor ID	WK 26
1	1234	1
2	1234	1
3	1234	0
	Grand Total	2

Creating a measure to calculate as per logic.. 

[ValtteriN]

Hi,

Try using this kind of measure:

48> = IF(SUMX('Table (7)',HOUR('Table (7)'[Actual Login (Logn-Break)]))>=48,1,0)

End result:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[Anonymous]

Hi,

if login hours greater then >48 hrs then it's counts how many empid exceeds after 48 hrs.

hope this logic will clear to you.. 

[Anonymous]

Hi,

Thanks for this solutions !!

For >48 column total it is showing 1 instead of 2..

how can i fix this..

[Anonymous]

can you reply  @ValtteriN

[ValtteriN · Accepted solution]

I see, in this case you can use the condition as a filter. E.g. 

COUNTROWS(

    FILTER(

SUMMARIZE('Table (7)','Table (7)'[EMP ID],'Table (7)'[Week],"hours",SUMX('Table (7)',HOUR('Table (7)'[Actual Login (Logn-Break)]))),[hours]>=48)

)

The FILTER part will return table like this:

Then countrows couts the correct amount of rows.

[Anonymous]

Thank you so much ..