Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all,
I am using direct query and have this problem:
I want to count the useres which are not active since three months. Because of that I've created a measure which claculates the diffrence between today and the last active day for the users, so 1 for not active , 0 for active .
Is inactive user since 90 days = IF( DATEDIFF(MAX('table'[TimestampUtc]);NOW();DAY)>90;1;0)
It works well !
But when I need to create other measue which calculates the the count like this, I get this error:
count of inactive users = CALCULATE(DISTINCTCOUNT('table'[UserId]);[Is inaktiver Nutzer seit 90 Tagen]=1)
I have read that, this formula is not supported in direct query, so I went another way with a table like this but it doesn't count the number of 1 ( it seems it shows the average):
What should I do !!
Thanks for Help 🙂
Taher
Solved! Go to Solution.
Give this a shot
count of inactive users = CALCULATE ( DISTINCTCOUNT ( 'table'[UserId] ), FILTER ( ALLSELECTED ( 'table'[UserId] ), [Is inaktiver Nutzer seit 90 Tagen] = 1 ) )
Give this a shot
count of inactive users = CALCULATE ( DISTINCTCOUNT ( 'table'[UserId] ), FILTER ( ALLSELECTED ( 'table'[UserId] ), [Is inaktiver Nutzer seit 90 Tagen] = 1 ) )
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
65 | |
60 | |
56 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |