Forum Discussion
Matrix visual not displaying the expected result
I tried this before but I couldn't append those 3 tables because I didn't have the same columns name.
But I found a workaround. I created a calculated column in each table where I concatanate the Subcategory and Category and I linked all the tables through this columns and then I was able to link the Data_Table with every table. After this I was able to see in the matrix the right values on the right column data for each measure.
Your idea of linking those 3 tables via calculated columns was useful, but the formulas were not changed because I got the correct result after I worked on the relationships.
Thank you lucadelicio for your ideas!
I tried this before but I couldn't append those 3 tables because I didn't have the same columns name.
But I found a workaround. I created a calculated column in each table where I concatanate the Subcategory and Category and I linked all the tables through this columns and then I was able to link the Data_Table with every table. After this I was able to see in the matrix the right values on the right column data for each measure.
Your idea of linking those 3 tables via calculated columns was useful, but the formulas were not changed because I got the correct result after I worked on the relationships.
Thank you lucadelicio for your ideas!
Happy to be helpful.