Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Frankcf
Frequent Visitor

changing how a total is calculated

i have created a power bi report using a table layout. i am reporting to the # of cases using the production orders as a base.

the following example displays the issue that i am having. the production order contains many lines of instructions, but the total order is for 100 cases.  but as you can see the report displays 100 per production order line. i would like the report to report the total # of cases based on the production order # and the not the individual lines listed in the production order. any help would be appreciated. Regards Frank

 

bi question.jpg 

1 ACCEPTED SOLUTION

Hi Frankcf,

 

From the image you posted, I suspect you are using Matrix, there is total Row available to show the total value at the bottom of each Row fields.

19.PNG

Currently it is not available to display the totals in the same row under Matrix Visual in Power BI.

Table and Matrix Visuals have their own Total calculate functions, and we could also create measure or calculate column to compute the total we want.

To use the total within the visual, we need enable the show total under Format part of the visual. And the total here would have their own limitation.

For detailed information based on Table and Matrix, please check:

How to Use Tables and Matrixes

Regards

 

View solution in original post

3 REPLIES 3
Frankcf
Frequent Visitor

thanks for you thoughts, i will look into the setups and the visulations

Hi Frankcf,

 

From the image you posted, I suspect you are using Matrix, there is total Row available to show the total value at the bottom of each Row fields.

19.PNG

Currently it is not available to display the totals in the same row under Matrix Visual in Power BI.

Table and Matrix Visuals have their own Total calculate functions, and we could also create measure or calculate column to compute the total we want.

To use the total within the visual, we need enable the show total under Format part of the visual. And the total here would have their own limitation.

For detailed information based on Table and Matrix, please check:

How to Use Tables and Matrixes

Regards

 

cosborn1231
Resolver I
Resolver I

Hi @Frankcf,

 

Not knowing if every instruction has a value of 100 in the Case column in the base table or not this may not work.

 

I would frist check the tables visualization pane,  within the values section for Case and see if the column has been set to sum or something strange and try exploring setting it to do not summarize or count.

 

Also, I would suggest changing the visualization to a matrix table so you can expose the totals per product order number.

 

Hope this helps to a solution,

Christian

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.