Forum Discussion
Top 15 Values
Hi all, I'm really beginning to lose my rag with RANKX and TOPN, or at least in trying to work out what I'm doing. I want to be able to isolate the top 15 rows in my table, including the top ...
Not going to lie. I have no advice as I have been in the same boat for 40 hours now. I do not undstand why we can't use SQL to create some views in Power BI because DAX gets real messy.
I am trying to get the Top 5 ranked builds off of my Top 15 categories ranked by sales$'s and no matter what I do the data change when I change the format of the visual. Meaning including a measure or not.
EXAMPLE:
Build Rank on Top 15 =
RANKX(
FILTER(ALL(Gender_Category[Gender Category]), [CategoryRankLastWeek] <= 15 ),
[Build],
,
DESC,
Dense
)
It's NOT USING MY TOP 15! And why is "4" repeated so much when those numbers it is based off not even close to the same value???