Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have 5 tables all with their own seperate Total Revenue Calculation formulas. In each table I have created a Total Revenue Measure. Now I would like one big table that shows all the Total revenue measures in the same column so my goal is to have something that looks like this.
TABLE NAME | TOTAL REVENUE |
Table 1 Name | Total Revenue in table 1 |
Table 2 Name | Total Revenue in table 2 |
Table 3 Name | Total Revenue in table 3 |
Table 4 Name | Total Revenue in table 4 |
Solved! Go to Solution.
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.
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.
One more question: Is this added as a table formula, or measure? Seems like I am building a new table then putting this as the formula? Is that correct?
This looks great, will give this a try!
Thank you for the help!
I already have a CALENDAR table that they all connect to
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.