DAX Help: Filtering out inactive customers/Creating usage metrics for active customers

[CH_Analytics]

Hi All,

Working on a custom PBI Usage Analyis report using a list of user stats over the last 18 months. I am trying to show what the usage is amongst active AD Group members (folks who have access to our PBI products and are actually going into PBI to view them). 

I have 2 main tables, one has all the AD Groups and their respective members. The second table is the PBI usage report that has all the folks who have access PBI since Oct 2021. These two tables are joined by a shared email column. This allows me to identify which AD Group the users belong to and how many views these groups have made. The issue is, the AD Group Member table has a lot of inactive users and their inclusion in my report is skewing the utilization rate (PBI users/All AD Group Members) as the denominator is full of non/inactive users. What would be the best way to identify and filter out inactive users based on date ranges such as the last 3/6/12/18 months?

I am fairly new to DAX, so trying to figure out how to filter out the inactive AD Group Members out has been quite the struggle. I cannot figure out how to use the PBI usage report to filter the AD Group one to flag someone as active/inactive based on whether or not they show up on the PBI Usage table in a set timeframe. 

Also, if anyone has made a custome PBI utilization report, please feel free to share some tips/ideas.

Thank you in advance!

[lbendlin]

You are mixing two concepts

- net new users from your AD pool that haven't used Power BI before your selected period

- return users that have used Power BI before your selected period

You can abstract that and say "report on users that had 0 to x visits before the selected period and y visits in that period.

Usual disclaimer:  Be sure what you want to measure.  Number of active users is meaningless if no actions result from these visits.   You can have reports with a single visitor in a month but that visitor happens to be your CEO and they got the insight they needed to make a strategic decision.