Secure Your Seat for the 2018 Power BI World Tour!

[MindyJ]

The Power BI World Tour is back! These value packed two-day events will take place in eight cities over the course of four months. Registration is open – secure your seat today to engage in this local learning opportunity!

Whether you are local to the area, traveling from near or faraway, the Power BI World Tour will provide exclusive learning and networking opportunities. Don't miss the opportunity to get involved in one or more of these amazing event locations, as either a speaker or attendee. Call for Proposals remains open until July 30 for the following locations: Seattle, Montreal, Dubai and Dallas.

One Sydney attendee last year raved, “the different speakers provided great and varied content. [I] loved the different streams that you could pick. Fantastic conference and great value for money.”

Expand your world of experience, grow your network of connections, and get ready to become the Power BI expert you were meant to be. Early bird registration savings end on July 10^th for all locations. #PBIWorldTour

[aaarmstee67]

I am working on a project. I need to create a dynamic top n which should work when different slicers are used. I used RankX which gives me the results i need when i group on only one column, eg clientgroup, but the issue arises when i add different columns, such as ClientGroup, SalesLocation, SalesPersonName, HoursWorked. The results is not right when i apply different slicers.  I tried to create a column for rownumber so that i can get the dynamic topn, that is if the row number can default to start from 1 with increment of 1 whenever any filter is applied. But this is becoming more difficult than i thought. Can anybody help. Urgent please. I have spent several days on this but to no avail.