Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
83 | |
77 | |
40 | |
40 | |
35 |