User of a security group are not able to access the Dashboard

[Anonymous]

User in a Security Group unable to access the content in the PowerBI Dashboard.

[Anonymous · Accepted solution]

Hi, @Anonymous 

According to my research, the main reason for this problem is that you are using data from different tables and you are filtering the metric values with fields from different tables.
Below I will demonstrate to reproduce your question:

I have the following three tables:

Their relationship is as follows:

Use the fields of these three tables to build a visual, and then exclude one of them:

As a workaround for this error, you can use Power BI Desktop's filter to uncheck the fields you want to exclude in the filter for the current visual, which can also show the results after you want to exclude data. Alternatively, you can use advanced filtering to exclude fields that have an IS NOT:

You can refer to the following articles:

Understanding the "A measure is used in cross highlighting" error in Power BI (crossjoin.co.uk)

Fix Power BI Cross Highlight Not Working [6 Quick Ways] (10pcg.com)

Solved: Cant display this visual because a measure is used... - Microsoft Fabric Community

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.