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.
I have a table visual with multiple categorical columns (Sponsor ID, Online Name, Subscriber ID, Last Name, Remit Center, Status) and descending sorted by Payment Amount as shown below. I would like to list top 50 lines, how may I do it? The "Top N" filter is good when there is only 1 categorical column. But it doesn't work as expected with multiple categorical columns.
Thanks.
@bergen288 , Try like
2 column top N = CALCULATE([Net], TOPN(10, SUMMARIZE(ALLSELECTED('Item'), 'Item'[Brand], 'Item'[Category]), [Net],DESC),VALUES('Item'[Brand]), VALUES('Item'[Category]) )
or
2 column top N = CALCULATE([Net], keepfilters( TOPN(10, SUMMARIZE(ALLSELECTED('Item'), 'Item'[Brand], 'Item'[Category]), [Net],DESC) ) )
amitchandak:
I tried a simple table with 2 categorical columns first. Below is my measure based on your 2nd suggestion:
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 |
---|---|
111 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |