Forum Discussion
Solved
Additional calculation row in matrix
Is there a way to add a line item labeled "Calculation" which takes the ("Total Sales" + "Operating Costs")/"Operating Costs" for each year?
Hi Gingy2217,
Please find the attached pbix file with your solution implemented.
Additional calculation row in matrix.pbixIf this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks!
Best Regards,
Maruthi
LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/
X - Maruthi Siva Prasad - (@MaruthiSP) / X
You need to create an additional row to your dim table where your "FS Description" is stored.
Then create a conditional measuse (like IF "FS Description" = "Calculation", Ventas totales" + "Costos operativos")/"Costos operativos).
Just to give you an idea without knowing your structure of data model