cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rms1 Frequent Visitor
Frequent Visitor

Table Header should show Product Name with Count

I have table data having column Product and Place, which has string values.

Requirement is to show the data for each Product in a separate List where each List Header should show Product Name with Count of rows matches of record Like ProductName(NumberofRecords) with Place also all rows should show count of records repeated in the table.

Sample Data as Below :

TableName
Id     Product       Place
1      Apple           Kashmiri
2      Orange         Nagpur
3      Orange         Spain
4      Tomato         Italy
5      Orange         SouthAfrica
6      Apple           American
7     Apple           Indonesian
8     Apple           Argentina
9     Apple           Italy
10   Apple           Kashmiri
11   Apple           Kashmiri
12   Apple           Kashmiri
13   Apple           Kashmiri
14   Orange         Nagpur
14   Orange         Nagpur
14   Orange         Nagpur
15   Apple            Indian
16   Apple           American
17   Apple           American
18   Apple           American
19   Apple          Argentina
20   Apple          Argentina
21   Orange        Spain
22   Orange       SouthAfrica


Result should be Like in different List or a Visual Table in a Single Column for each Product Records :

 

 

1st list should as below 
=============
Apple(15)-->Header of Table Header in Visual in Report Pane
----------------
Kashmiri(5) -> row
American(4) -> row
Indonesian(1) -> row
Argentina(3) -> row
Indian(1) -> row
Italy(1)

 

2nd List as below

==============^

Orange(8)--> Header
Nagpur(4)--> rows
Spain(2) --> rows
SouthAfrica(2) -->rows
===============^

 

3rd list as below

Tomato (1)

Italy(1)

2 REPLIES 2
Community Support Team
Community Support Team

Re: Table Header should show Product Name with Count

Hi rms1,

 

Simply create measures using 

Count1 =
COUNT ( Table[Product] )

Count1 =
COUNT ( Table[Place] )

Then drag Product column and Count1 into a visual, drag Place column and Count2 into a visual.

 

Regards,

Jimmy Tao

Community Support Team
Community Support Team

Re: Table Header should show Product Name with Count

Hi rms1,

 

Does the answer helps you? if it is, could you please kindly mark the answer to finish the thread?

 

Regards,

Jimmy Tao

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 391 members 4,063 guests
Please welcome our newest community members: