Forum Discussion
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
6 Replies
- Syndicate_AdminAdministrator
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 - maruthispSuper User
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
- danextianSuper User
Hi Gingy2217
You cannot assign a value to a row that doesn't exist so that extra row must exist first in your table. Please check out this tutorial. A link to a sample pbix is in the video description. https://youtu.be/R5fCJP6x03Y
- v-achippaCommunity Support
Hi Gingy2217,
Thank you for reaching out to Microsoft Fabric Community.
Thank you danextian, maruthisp and Syndicate_Admin for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Thanks and regards,
Anjan Kumar Chippa
- v-achippaCommunity Support
Hi @Gingy2217,
We wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Thanks and regards,
Anjan Kumar Chippa
- v-achippaCommunity Support
Hi @Gingy2217,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Thanks and regards,
Anjan Kumar Chippa