Forum Discussion
Top 3 records
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 |
Top N filter in the filter pane should work:
Count Sub-Product = SUM(SampleTable[Count of Sub Product])
7 Replies
Preeti_YadavResolver I
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
No Preeti, TopN from filter is not working.
PaulDBrownCommunity Champion
Top N filter in the filter pane should work:
Count Sub-Product = SUM(SampleTable[Count of Sub Product])Hello Everyone, Can someone provide the solution on my request. Thank in advance.
Regards,
- Ashish_Mathur
Super User
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.
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.
