Forum Discussion
Solved
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 ...
Top N filter in the filter pane should work:
Count Sub-Product = SUM(SampleTable[Count of Sub Product])
Ashish_Mathur
Super User
Super UserHi,
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.