Forum Discussion

JLambs20's avatar
JLambs20
Helper III
4 years ago
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...
Need Help
  • danextian's avatar
    danextian
    4 years ago

    Hi JLambs20 ,

    You can create a measure from two unrelated tables in DAX.  You can have something like

    MyMeasure =
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.

danextian's avatar
danextian
Super User
4 years ago

Hi JLambs20 ,

You can create a measure from two unrelated tables in DAX.  You can have something like

MyMeasure =
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.