Forum Discussion
Create defined subtotal in a matrix
Hi Catman,
I believe that is a common challenge.
I believe you have two options.
Option 1: Use one of the following custom visual, where you can add the subtotal row in the custom visual itself, as a new calculation.
https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200000642?tab=overview
https://appsource.microsoft.com/en-in/product/power-bi-visuals/mscrm.d365_business_performance_planning_reporting?tab=Overview
Option 2: Create a skeleton for the rows in Power BI by entering the following rows in a new table.You can then use this table to create a new measure that checks this context.
Personally i prefer the first option.
Feel free to reach out if you have any further questions.
Best Regards
Mathias Andersen
BI Consultant at TRIMIT
@: [email protected]
Hi Catman,
I believe that is a common challenge.
I believe you have two options.
Option 1: Use one of the following custom visual, where you can add the subtotal row in the custom visual itself, as a new calculation.
https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200000642?tab=overview
https://appsource.microsoft.com/en-in/product/power-bi-visuals/mscrm.d365_business_performance_planning_reporting?tab=Overview
Option 2: Create a skeleton for the rows in Power BI by entering the following rows in a new table.
You can then use this table to create a new measure that checks this context.
Personally i prefer the first option.
Feel free to reach out if you have any further questions.
Best Regards
Mathias Andersen
BI Consultant at TRIMIT
@: [email protected]