Inactive relationship between two table issue

[nehajadhav166]

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

[nehajadhav166 · Accepted solution]

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

[PijushRoy]

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 relationship

Please 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 model

If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos

[nehajadhav166]

@PijushRoy 

I created Table 1 using excel,importing excel.

Is that issue?

In relationship model there is no connection between these two table.

Thanks,

Neha