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
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi Shamatix,

Shamatix wrote:

Ye I tried that, but aint really what I want,

I want the following 

 

Where the new columns number just says "Okay there is 10 rows for Name1 in tableB, 0 rows for Name 2 in Table b, 0 rows for Name3 in table B" etc etc 

As far as I know, there isn't an easy way to do this currently. :smileyhappy:

 

Regards

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?