Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Average DAX Measure not working as expected

Hi Experts

 

I have the following measure - which gives me the correct end ANSWER but when i apply my role level security - i would expect the meauere to return back zero value not an average value.

 

Measure

Avg. Time Store = AVERAGE(avgtime_case_close_by_store[avg_days])+0
 
Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Anonymous , do you have some data for that role ?

     

    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

     

    Power BI- Row Level Security: Handle ALL, UserPrincipalName: https://youtu.be/KVLEnIUo4pc