Forum Discussion

Frankcf's avatar
Frankcf
Frequent Visitor
10 years ago
Solved

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 producti...
Need Help
  • v-micsh-msft's avatar
    v-micsh-msft
    10 years ago

    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.

    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's avatar
cosborn1231
Icon for Resolver I rankResolver I
10 years ago

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