Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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)
Hi rms1,
Does the answer helps you? if it is, could you please kindly mark the answer to finish the thread?
Regards,
Jimmy Tao
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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |