Forum Discussion
Derive Column based on Slicer selection
thank you.. i created the many to many releationship by using the bridge table.
this way i created the relationship b/w my transaction to fail code mapping with duplicate entries ( 1 entry for eng and 1 entry for danish). that solved my issue..
more details refer below link
https://www.seerinteractive.com/blog/join-many-many-power-bi/
Peter_Jeyaraj_I Here is the steps I've followed to solve this..
Create a new calculated table from your main table as below:
Test21ChartNew = UNION(
SELECTCOLUMNS(Test21Chart,"Code",[Code],"FailCategory",[FailCategory])
,SELECTCOLUMNS(Test21Chart,"Code",[Code],"FailCategory",[FailCategory_D])
)The output will be as :
Similary, create a lookup table as below
Test21ChartSlicer = DISTINCT(
UNION(
SELECTCOLUMNS(Test21Chart,"Language","English","FailCategory",Test21Chart[FailCategory])
,SELECTCOLUMNS(Test21Chart,"Language","Danish","FailCategory",Test21Chart[FailCategory_D])
)
)
This will be result to as below:
Now make sure these two tables have relationship on FailCategory field. That's it, now you have your output as expected.
Thanks for your response.
but i need to maintain the unique values in fail code table as i have code - code relationship b/w master table( kind of transaction table) and fail code table.
that is the reason why i created new columns to accomadate other language values.