Forum Discussion
Maria7
3 years agoFrequent Visitor
Matrix visual not displaying the expected result
Hello everyone, I need some help with a problem I am encountering when creating a visual matrix table. I have 3 measures that are calculated in different tables, a Data_Table that is connected t...
- 3 years ago
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!
lucadelicio
3 years agoImpactful Individual
Can you upload the pbix file?
Thanks