Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to Solution.
Top N filter in the filter pane should work:
Count Sub-Product =
SUM(SampleTable[Count of Sub Product])
Proud to be a Super User!
Paul on Linkedin.
Top N filter in the filter pane should work:
Count Sub-Product =
SUM(SampleTable[Count of Sub Product])
Proud to be a Super User!
Paul on Linkedin.
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.
Hi,
In the Query Editor, change the Data type of that column to Numeric.
Hello Everyone, Can someone provide the solution on my request. Thank in advance.
Regards,
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |