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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
JoeChamp
Frequent Visitor

Having trouble getting to a Count of users with greater than 50 views for a given set of dashboards

I'm using the audit log data and want a metric for a count of users with 50 or more views for the already fitered dataset.  So my dataset is filtered down to a handful of dashboards and the ViewDasbhboard events.  I have a count of the views and count of the users.  I'd like to count users that have 50 or more views.  Having trouble getting to that.  Tried a calculate with a filter on Views>50 but it doesn't like true false in calculate.  calculate(counta(users),[views]>50).  Tried bring the [views] aggregated measure into the card filter but it doesn't allow for filtering on that.

 

Would also like to add a metric of users counts >50 by dashboard as well.  Any direction would be appreciated.  Thanks.

2 REPLIES 2
v-caliao-msft
Microsoft Employee
Microsoft Employee

@JoeChamp,

 

Could you please provide us some sample data? Generally, we could use the sample DAX to filter the data
CALCULATE (

    <expression>,

    FILTER (

        ALL ( table[column] ),

        table[column] = <value>

    )

)


In your scenario, please try to use the DAX below.
calculate(counta(users),filter(all(tablenale),tablename[views]>50))


Regards,
Charlie Liao

CahabaData
Memorable Member
Memorable Member

Am a little confused with your post.  You discuss dashboards which is Service.  But in terms of Reports - it is not clear if you are working at the table level with a Dax Calculation or whether you could be working at the Report level with a visual Level Filter.

 

In general at the Report Level - one can apply a Visual Level filter such as >50 but you probably already realize that.

www.CahabaData.com

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors