Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rms1
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
v-yuta-msft
Community Support
Community Support

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
Community Support
Community Support

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.