Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
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
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.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 97 | |
| 73 | |
| 50 | |
| 46 | |
| 44 |