CODEWITHSUNDEEP
filterpowerbidaxslicers
Amy Qutaish
Amy Qutaish

Reputation: 11

Power BI DAX: Find total amount of bookmarks from only top 10 users?

This is the current data table that I have, which is called 'Bookmark Information'. Click to see table I need to do 2 things:

  1. Create a measure to find the total count of bookmarks per each bookmark title, but only from the rows that are the top 10 highest numbers in the column "Number of submission breaktie column".

  2. Since I will later on add a date slicer, it should also only show me the top 10 highest numbers in the column "Number of submission breaktie column" per the date range in the slicer and the corresponding total count of bookmarks per each bookmark title.

I have tried something like this, but it is not giving me the correct number:

Sum of Bookmarks = SUM(Bookmark Information [Count of Bookmark])
Top 10 total bookmarks = CALCULATE([Sum of Bookmarks], TopN(10,'Bookmark Information','Bookmark Information'[Number of Submission breaktie column],DESC))

Upvotes: 0

Views: 238

Answers (2)

Ashok Anumula
Ashok Anumula

Reputation: 1515

You can use Top N in Advanced filtering on "Filters on this visual" to get the result

enter image description here

You can add Date slicer up on it.

Upvotes: 0

user14198297
user14198297

Reputation:

Use code like this = sumx(values[tablecolumn]), if(measure) > 0, 1, blank()).

Upvotes: 0

Related Questions