Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

DAX Help with Hierarchy

Hi, I have three tables below in my data model For Actual and Forecast table, each activity type can either be operating or capital. I want to show the following result in my matrix: S...
Need Help
Show and Tell
  • MFelix's avatar
    MFelix
    8 years ago

    Hi Anonymous,

     

    • Create a new table Activity_Dim with the row being each of your Activity types
    • Relationship between that table and the Actual and Forecast Table.

     

    • Add the Column activity Type to your table to see the final result (I don't have values for the 0 in your table that is why it's null)

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Super User
8 years ago

Hi Anonymous,

 

  • Create a new table Activity_Dim with the row being each of your Activity types
  • Relationship between that table and the Actual and Forecast Table.

 

  • Add the Column activity Type to your table to see the final result (I don't have values for the 0 in your table that is why it's null)

 

Regards,

MFelix