Forum Discussion

tmendoza's avatar
tmendoza
Resolver I
7 years ago

(Managing Roles) Assigning Row-Level Security with Measures Is Making Visuals Go Blank

 

 

Hello all,

 

This is my first time posting to the community, so I hope this works.

I've been banging my head against my monitor trying to figure this one out.

 

I've got a table that counts the number of employee's by their Job Title, Level and Job Family.

What I'm trying to do is assign a Role that does not allow folks to see Rows that have an Employee Count of 2 or below.

This could allow people to figure out salaries based off of the other visuals that express labor costs.

"Employee Count" is a measure expressed by (DISTINCTCOUNT('Employee Detail'[Employee]). I'm trying to use this in my DAX formula; however, the formula is making all my visuals go blank.

I've also tried this DAX expression that exclueds the measure, but still makes all my visuals blank.

DISTINCTCOUNT([Employee])>"2".

 

Can anyone offer my a solution that will allow me to create a role that will stop people seeing any rows that have an employee count of 2 or below.

 

Thanks,

 

Tom

 

 

 

5 Replies

  • Stachu's avatar
    Stachu
    Community Champion

    Hi, can you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data? 

    Column1 Column2
    A 1
    B 2.5

    Specifically the Employee Detail table as well as the measures that you show in the visuals
    As described here:

    How to Get Your Question Answered Quickly 

    • tmendoza's avatar
      tmendoza
      Resolver I

      I can do better than that. I've got a PBIX file that has been redacted that has everything in it to mimic my problem. Just not sure how to send it out to the community.

      • Stachu's avatar
        Stachu
        Community Champion

        usually peopple post on OneDrive Google Drive, would that work for you?