No of active users with 1 call across 3months call duration less than 10min

[Anonymous]

Any one please help for the dax how to solve the question 

[v-zhangti · Accepted solution]

Hi, @Anonymous 

I simulated some data, hoping to restore your problem.

Count =
CALCULATE (
    COUNT ( 'Table'[User] ),
    FILTER ( ALL ( 'Table' ), [Call duration] < 10 && COUNT ( 'Table'[User] ) > 1 )
)

Does this solve your problem? If it doesn't solve it what kind of results do you expect? Is it possible to provide a short version of the PBIX file for testing? Looking forward to your response, thank you!

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous ,

New measures

Cnt = Countrows(Call)

Duration = sum(call[Call Duartion in Min])

Active = Countx(filter( values(Call[customer]), [cnt] >1 && [Duration] <=10) , [Customer])