I use power bi with live connection to SQL analysis server so I can not create tables, relationship etc. I have only access to creating measures.
If I have different types of revenues such as revenues x, revenues y, and other revenues, can I create a roll up category called revenue so I can sum all revenues using a matrix. I do not want to have a measure since this will create a new column and I already have budget and actual column to sum the revenue on both.
Actual. Budget. Actg to be created
Revenue x. 100. 130. Revenue
Revenue y. 300. 280. Revenue
Other Rev. 10. 8. Revenue