Forum Discussion

pupu23's avatar
pupu23
New Member
1 year ago
Solved

Making linked categories

I have 2 Columns named "Category" from 2 different models. 

Annualized Attrition Rate is a created measure. 

 

I'm trying to create a matrix table however it always shows incorrect values unless both category values 'match' (e.g. Category A = Category A, in this case 10% is the correct annualised attrition rate).

 

How can I link the 2 categories together such that the incorrect values do not show up, or unhide the rows with the incorrect attrition values?

 

 

Need Help
  • MFelix's avatar
    MFelix
    1 year ago

    Hi pupu23 ,

     

    Not sure how the model is setup and the relationships between the tables are done, but have you tried creating a status dimension table and relating both table by tha dimension? 

    That could allow to have the Category A single column and then the correct measure.

2 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    1 year ago

    Hi pupu23 ,

     

    Not sure how the model is setup and the relationships between the tables are done, but have you tried creating a status dimension table and relating both table by tha dimension? 

    That could allow to have the Category A single column and then the correct measure.

    • pupu23's avatar
      pupu23
      New Member
      1 year ago

      The relationship was the solution, many thanks!