need to create matrix table with scenario

[adityapv]

Hi all,please help me with the scenario.

please check the attached image.

[negi007]

@adityapv in this case, i would suggest you to merge these two tables into one and in your merge table you will have one column for objective (A, B, C, D) that way you can have values against A as well. Othewise in the current scenario you may not be able to show values against A in status column. 

Using your current data, I was able to create below but not value seperatly will appear against A in status column

[adityapv]

Hi thanks for the reply,but unfortunately i need as it is.like which i mentioned in the image.i am trying to achieve using dax but at the end of the dax i am unable to get the condition.thanks for the reply.if possible can you please try with the dax.

[v-lionel-msft · Accepted solution]

Hi @adityapv ,

Please refer to my .pbix file.

Note: Remove relationship between two tables.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.