Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
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
| User | Count |
|---|---|
| 51 | |
| 40 | |
| 35 | |
| 23 | |
| 22 |
| User | Count |
|---|---|
| 134 | |
| 103 | |
| 57 | |
| 43 | |
| 38 |