Table Header should show Product Name with Count

[rms1]

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)

[v-yuta-msft]

Hi rms1,

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

Regards,

Jimmy Tao

[v-yuta-msft]

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