Forum Discussion

hyreddy_016's avatar
hyreddy_016
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Measure referring to a column restricted using Column Level Security

I have a use case where I need to evaluate a count based on the column filtered in a report. If the visuals are sliced using A or B, the count should evaluate to 0 else 1. Following are more details...
hyreddy_016's avatar
hyreddy_016
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Hi amitchandak , the role member is an azure active directory group and not individual user. Hence I can not add the user related condition in the query. I have added the role name, even then this measure is getting restricted. Could you please provide an example?

hyreddy_016's avatar
hyreddy_016
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Is there a way we can verify for role membership in a measure using DAX?