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...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

hyreddy_016 , you need to add condition for role or username in this

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?