Forum Discussion
Issue with Missing data in Calculation
Some lessons are included while others are missing in the calculation. Example of Missing Lesson in Calculation For example, a user conducted a lesson on 10/16. Since today is 10/21, the les...
Hello ginalu
You can use below DAX
Recent7DaysActiveUsers =
CALCULATE (
DISTINCTCOUNT ( USERUNQ[user_id] ),
FILTER (
Summarize(
LESSONN,LESSONN[start_time],LESSONN[teacher_id]
),
TRUNC ( LESSONN[start_time] )
>= TODAY () - 7
&& TRUNC ( LESSONN[start_time] ) < TODAY ()
),
USERUNQ[user_id] = LESSONN[teacher_id]
)
instead of filtering whole table, you can summarize the table with required columns.
Regards
sanalytics
Hi @sanalytics
Thank you for your reply. I tried it, but an error message appeared:
The expression includes columns from multiple tables, but only columns from a single table can be used in a True/False expression for table filtering.
