Forum Discussion

Shamatix's avatar
Shamatix
Icon for Post Partisan rankPost 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
Icon for Post Partisan rankPost 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's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft 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