Average DAX Measure not working as expected

[Anonymous]

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

[amitchandak]

@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