Forum Discussion
Filter dimension values based on User selection
Hi Anonymous
Thanks for the reply!i was trying to acheive it with the ways it works in other BI Tool.
i didn't had relation between these 2 table wanted to acheive something like if( selection in Table1(field) =User, Table2[show tool only with User data](Filtered tools column) , Table2[show all tools]Made some data model changes and got the solution.
Created NewTable1 with 2 column, Type and tool name from Table2.
- First added tools with only user data and type-User
- added all tools with type- Team
Created relation based on Tool column between NewTable1 and Table2
Hi Anonymous
Thanks for the reply!
i was trying to acheive it with the ways it works in other BI Tool.
i didn't had relation between these 2 table wanted to acheive something like if( selection in Table1(field) =User, Table2[show tool only with User data](Filtered tools column) , Table2[show all tools]
Made some data model changes and got the solution.
Created NewTable1 with 2 column, Type and tool name from Table2.
- First added tools with only user data and type-User
- added all tools with type- Team
Created relation based on Tool column between NewTable1 and Table2
Hi Anonymous ,
It's glad to hear that you got the solution. And thanks for sharing your solution here. Could you please mark your post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.
Best Regards