Forum Discussion
Solved
Create a Matrix between two unrelated tables
Hello, I have a column in a table that contains the row headers I need for a matrix. However, for my columns, I need to have the numbers 1-30 (so, 30 columns) that correspond to a month. This i...
Hi JLambs20 ,
You can create a measure from two unrelated tables in DAX. You can have something likeMyMeasure = DIVIDE ( SUM ( Table1[Column] ), SELECTEDVALUE ( DaysTable[Day] ) )The matrix will return an error if you put in the two fields from unrelated first but should be fine after adding the measure. If this doesn't work, please post a sample data that we can copy-paste.
I completely forgot the fact that measures will help out with unrelated tables! Gosh, that's quite the oversight on my part. Thank you for your help!