Forum Discussion
Combining like measures for different tables
Hi nhodges ,
Is this what you want? Define the row header first, and then you can define which measure to use in each row.
I have a dummy file for reference, please replace the table and measure to your own. Thanks.
srry am unable to open the file because it is restricted at my work.
Oops, let me explain the steps below:
1. Create a new table with your table name as row header [Metric].
2. Create measure to define which measure to use in each row [Total Revenue].
3. Put the [Metric] and [Total Revenue] into your table visual.
Total Revenue =
SWITCH(TRUE(),
SELECTEDVALUE('Table'[Table Name]) = "Table1", [Total Revenue in Table 1],
SELECTEDVALUE('Table'[Table Name]) = "Table2", [Total Revenue in Table 2],
SELECTEDVALUE('Table'[Table Name]) = "Table3", [Total Revenue in Table 3],
BLANK())
You're awesome thank you!
If I wanted to break it down month over month afterwards so something like this:
Would I follow similar steps? and just add on to the formula? but I wouldnt want to have to add a month each time, no sure if theres a way for that, but I can keep playing around with it.
Hi nhodges ,
I think it depends on the relationships in your data model, but ideally you can create a matrix and put the month column into the row. Thanks.