Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Is there a way to sum Online and offline columns into a third column called TOTAL MEDIA. Below is a sample image of what needs to be summed.
The third section will be called Total media summing all the values like show below
Solved! Go to Solution.
@UditJ , Add a column in the table having the column having value offline and online
New column = "Total Media"
and use that in Visual
Or rename Grand total or Sub Total as Total Media
Or create a table with these values
| C1 | C2 |
| Online | Online |
| Offline | Offline |
| Online | Total Media |
| Offline |
Total Media |
Join C1 with you column with Many to Many join this new table filter you current table and use C2 from this new table in visual
@UditJ , Add a column in the table having the column having value offline and online
New column = "Total Media"
and use that in Visual
Or rename Grand total or Sub Total as Total Media
Or create a table with these values
| C1 | C2 |
| Online | Online |
| Offline | Offline |
| Online | Total Media |
| Offline |
Total Media |
Join C1 with you column with Many to Many join this new table filter you current table and use C2 from this new table in visual
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 79 | |
| 49 | |
| 35 | |
| 31 | |
| 30 |