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! Get ahead of the game and start preparing now! Learn more
I have 2 slicers: one choosing the year and one choosing the month (or months). I have two results: the total of the year an the total of the selected month(s):
I have the turnover of year X
I have the turnover of Months A - B - .. (minimum 1 month to maximum 12 months)
How can I now: Divide both results / sum both results etc. So avoiding measures or calculated columns?
If I can not avoid measures or calculated columns, please explain me how I can resolve this? I have next data:
table : alle afleveringen
Columns in this table = year / month / turnover
thank you
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 38 | |
| 37 | |
| 28 | |
| 25 |
| User | Count |
|---|---|
| 124 | |
| 87 | |
| 70 | |
| 66 | |
| 65 |