https://community.fabric.microsoft.com/t5/Report-Server/undefined/m-p/3261106#M29949 <P>Hi, Could anybody please help me with the below&nbsp;<BR /><BR />I have three tables<BR />1) Course table(has Roles, CourseName and uniqueID assigned to Course)<BR />2) Employee Table(Employee name, CourseName and UniqueID assigned to the coursename). This table gives the the courses completed by the employees based on their Roles</P><P><BR />I need to build SSAS model, when I select the Role(1st slicer) - CourseName related to the roles should pop up.&nbsp;<BR />(2nd slicer is employeeName) when I select EmployeeName among those Coursenames if there is anything he/she completed<BR />&nbsp;it should show green or else Red<BR />how do I build this</P> Wed, 31 May 2023 07:01:40 GMT Pratz 2023-05-31T07:01:40Z https://community.fabric.microsoft.com/t5/Report-Server/undefined/m-p/3261106#M29949 <P>Hi, Could anybody please help me with the below&nbsp;<BR /><BR />I have three tables<BR />1) Course table(has Roles, CourseName and uniqueID assigned to Course)<BR />2) Employee Table(Employee name, CourseName and UniqueID assigned to the coursename). This table gives the the courses completed by the employees based on their Roles</P><P><BR />I need to build SSAS model, when I select the Role(1st slicer) - CourseName related to the roles should pop up.&nbsp;<BR />(2nd slicer is employeeName) when I select EmployeeName among those Coursenames if there is anything he/she completed<BR />&nbsp;it should show green or else Red<BR />how do I build this</P> Wed, 31 May 2023 07:01:40 GMT https://community.fabric.microsoft.com/t5/Report-Server/undefined/m-p/3261106#M29949 Pratz 2023-05-31T07:01:40Z