Top 3 records

[mangal999]

Hello Everyone,

I am looking for a solution where I want to display top records count wise. Can you please help me. I have posted data below.

Product Number	Product Name	Sub Product	Count of Sub Product
80.3.1	Capacitor Aluminum Polymer	Circuit Breaker Accessories	7
80.6.1	Capacitor Aluminum	Circuit Breakers	5
80.3.3.2	Capacitor Ceramic Multilayer	Fuse Accessories	4
80.4.1	Capacitor Ceramic Single Layer	Fuses	3
80.5.1.2	Capacitor Electric Double Layer- Supercaps	PTC Resettable Fuses	3
80.5.1.3	Capacitor Feed Through	PTC Resettable Fuses	2
80.6.1	Capacitor Film	Surge Suppressors	2
80.5.1.3	Mica Capacitors	Thyristor Surge Protection Devices	1
80.4.1	Capacitor Niobium	Speech Network	1

[PaulDBrown · Accepted solution]

Top N filter in the filter pane should work:

Count Sub-Product = 
SUM(SampleTable[Count of Sub Product])

[Ashish_Mathur]

Hi,

Drag Sub product to the row labels of the matrix visual and write these measures

Subproduct count = sum(Data[Count of Sub Product])

Top 3 Subproduct count = calculate([Subproduct count],top(3,all(data[sub product]),[Subproduct count]),values(data[sub product]))

Hope this helps.

[mangal999]

@Ashish_Mathur , SubProduct column is string type so we can not sum the column. I have tried with count as well but its not working.

[Ashish_Mathur]

Hi,

In the Query Editor, change the Data type of that column to Numeric.

[mangal999]

Hello Everyone, Can someone provide the solution on my request. Thank in advance.

Regards,

[Preeti_Yadav]

Hi,

You can try to get top 3 from the Filters.

The following example shows the top 3 name by measure.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Best Regards,

Preeti

[mangal999]

No Preeti, TopN from filter is not working.