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!
How do I get column total and row today's balance to output what the bushels are for todays balance
Solved! Go to Solution.
Hi @jbenson
Either you can have slicers on column and Row and display the Bushels in a card so that the card displays based on selection
or, if these are hardcoded value you are looking for then craete the below measure and display it in a card.
_Total_Today_bal = CALCULATE(SUM(table[bushels]), table[column] = "Total", table[row] = "Today's Balance")
Hi @jbenson
Either you can have slicers on column and Row and display the Bushels in a card so that the card displays based on selection
or, if these are hardcoded value you are looking for then craete the below measure and display it in a card.
_Total_Today_bal = CALCULATE(SUM(table[bushels]), table[column] = "Total", table[row] = "Today's Balance")
| User | Count |
|---|---|
| 51 | |
| 38 | |
| 33 | |
| 22 | |
| 19 |
| User | Count |
|---|---|
| 136 | |
| 102 | |
| 59 | |
| 36 | |
| 35 |