Relationship not Working when applying view as role function

Question

Hi Again Experts,&nbsp;Good day!&nbsp;I have a problem with my dashboard and I think it's due to their relationship. When I applied the view as role function, the last dashboard which is reporting is not working. I did try to create a relationship but still doesn't work. I want to have a relationship between the Hierarchy and the reporting data. Here is an example of their data as attached. I know I need to create one relationship with unique values but I can't make it as it has more than one.&nbsp;Could you please help me to create a measure where I could create a relationship where the view as role function will work?Hierarchy:&nbsp;Employee Data As OfEmployee NoHR_Data_First NameHR_Data_Last NameFull NameStatusVar Plan IDVar Plan DescCountry2019-03-030009444AlexVan HalenAlex Van HalenActiveLXK01320OEM Account ManagerUnited States&nbsp;Reporting data:Empl_IDNameElementCountryPlan IDVar Plan DescJob TypeSales Plan Eff DtJob Data Chg DtLevelBusiness Area0009444Alex Van HalenTotal RevenueUnited StatesLXK01320OEM Account ManagerOEM Account Manager2018-01-012019-02-15OEMChannel0009444Alex Van HalenSupplies RevenueUnited StatesLXK01320OEM Account ManagerOEM Account Manager2018-01-012019-02-15OEMChannelPlease advise.&nbsp;Thanks&nbsp;

anonymous · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
How did you setup your relationship? Have you turn on 'apply security filter on both direction' option? It will affect security filter effect.

Regards,
Xiaoxin Sheng

Forum Discussion

Relationship not Working when applying view as role function

2 Replies

Related content

Relationship

Relationships

Relationship Issue

Creating relationships

PowerBI Relationships

Employee Data As Of	Employee No	HR_Data_First Name	HR_Data_Last Name	Full Name	Status	Var Plan ID	Var Plan Desc	Country
2019-03-03	0009444	Alex	Van Halen	Alex Van Halen	Active	LXK01320	OEM Account Manager	United States

Empl_ID	Name	Element	Country	Plan ID	Var Plan Desc	Job Type	Sales Plan Eff Dt	Job Data Chg Dt	Level	Business Area
0009444	Alex Van Halen	Total Revenue	United States	LXK01320	OEM Account Manager	OEM Account Manager	2018-01-01	2019-02-15	OEM	Channel
0009444	Alex Van Halen	Supplies Revenue	United States	LXK01320	OEM Account Manager	OEM Account Manager	2018-01-01	2019-02-15	OEM	Channel