Set Analysis with multiple conditions

[itsme123]

Please help me with two measures

ID column is trying to access documents which is store in datetime field

Col1 datetime; col 2 id ; col3 ; col4;  col5 ID count( this is created using id column)

i need to create measure to count how many id are being accessed during 10pm to 6am interval

I also need to create an other measure which should satisfy condition col3 <> col4  and count id > 3 then i need count how many accessed documents more than 3 times

[Taoufiq_Zarra]

@itsme123  can you share a sample data and the expected output ?

[Anil_Babu_Samineni]

@itsme123  Perhaps this way

Count(If(Time(datetime)>='10:00:00 PM' and Time(datetime)<='06:00:00 AM'), ID)

// Make sure, If Time(datetime) giving format with "hh:mm:ss TT"

Count({<Col3={"=Col3<>Col4"}, Id={"=Cound(Id)>3"}>} Documents)