Forum Discussion
Inactive relationship between two table issue
Hi Experts,
I have two table: first table is used for sorting and second table for calulating Cpk.
Table 1:
Table 2:
Realtionship error:
I am mapping Ylabel column from table 1 as Y column and X.1 coulmn from Table 2 as X column in matrix.
As there is no relationship between table my matrix is not populating correctly.
Lights should be green. I can see background value.
Can you help me with issue? How can I handle this?
Thanks,
Neha
Hello,
My issue is resolved.
Now I created sort by column in table 2 itself. So table 1 sorting table is not required anymore.
Thanks,
Neha
3 Replies
Hi nehajadhav166
How you build table 1, if you take reference of Table 2 (summarize, distinct dax function) to create table 1
May be shows error for relationshipPlease create Table 1 table by inserting of data (as lookup table only)
Can you please check and confirm
Can you please share image for relationship diagram for your data modelIf solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/KudosI created Table 1 using excel,importing excel.
Is that issue?
In relationship model there is no connection between these two table.
Thanks,
Neha
Hello,
My issue is resolved.
Now I created sort by column in table 2 itself. So table 1 sorting table is not required anymore.
Thanks,
Neha
