Forum Discussion

Shamatix's avatar
Shamatix
Post Partisan
8 years ago

Question regarding measure

 Hey fellow users of PowerBI,   I have a question regarding a measure and something I want to achieve. I have 3 tables Table A Column (Unique): Name   Table B (Main table) Ton of data   ...
General Comment
Need Help
Show and Tell
Shamatix's avatar
Shamatix
Post Partisan
8 years ago

Based on this post I now have the following matrix:

 

What is the total to the right? how can something be -400% it should just show the average of the row? but what is this showing, and since those values are wrong, can I either disable it or get it to show the average of the row?

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi Shamatix,

 

You can disable it by turning off Row subtotals and Column subtotals in the Format tab for the Matrix. :smileyhappy:

 

 

Regards

  • Shamatix's avatar
    Shamatix
    Post Partisan
    8 years ago
    v-ljerr-msft wrote:

    Hi Shamatix,

     

    You can disable it by turning off Row subtotals and Column subtotals in the Format tab for the Matrix. :smileyhappy:

     

     

    Regards

     

    What is it exactly the value is showing tho? As its not the average of the row?