Forum Discussion

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

Post Partisan

8 years ago

Nevermind I figured out the percentage, but I still havnt figured out the count pr names from data table, how to get it in.

Microsoft Employee

8 years ago

Try clicking the (expand all down one level in the hierarchy) on the left top of the table. :smileyhappy:

Regards

Shamatix
Post Partisan
8 years ago
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
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
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
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
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?