Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

PowerBI maximum Concurrent Callers - Stats DAX

Hi please can you help, i have data that has a call start date and time   Time_of_connection Time_of_Disconnection   in Date/ Time format   I also have a User_ID field;   i need to calculate...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

There is no need to create a relationship between DataTable1 and calendar table.

 

Regards,

Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
8 years ago

hi @ 

 

without a relationship it doesnt calculate anything at all. with a relationship it doesnt calculater correctly:(

 

this is the atcual formula im using;

 

Count Measure =
CALCULATE (
    COUNTA(data[callingPartyUnicodeLoginUserID] ),
    FILTER (
        Data,
        SELECTEDVALUE ( 'Calendar'[Date] ) >= data[Time of Connection]
            && SELECTEDVALUE ('Calendar'[Date]) <= Data[Time of Disconnection]
    )
)