Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

dax measure to calculate number of users with NO activity in last N dates

Hi,

I have a requirement where i need to calculate the number of users who did not use a system for the last 7 days.

I tried the below and gave me correct number but the table visual displaying columns Subsystem,Last_used,username is not filtering based on the measure and subsystem slicer

CALCULATE(counta(Users[username]),Date[FullDate]<TODAY()-7)
Users Fact: username ,last_used columns,system
Date Dim: FullDate,Year,Month columns
FullDate is related to last_used columnPBI_model.png

 

How do i achieve this as measure.
Aso,if someone can suggest how to pass the relative slicer value to the measure that counts number of users NOT using system in last N days,it will be great.
0 REPLIES 0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.