Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi All,
So I have the following calcluation to rank items that are sold by the invoicved amount and it works fine.
Product Running Total =
RANKX(
ALL(Sheet1[Item]),
[Total Inv Amount],,
DESC,
Dense
)
I have added more data to my report and created a second version:
Sales Ranking = RANKX(
AlL('Ames Sales'[Material]),
[Invoiced Sales],,
DESC,
Dense
)
This uses a different table which i have refernced and rather than getting ranks of 1,2,3,4 etc, every row evaluates to 1.
Any thoughts as to why this may be happening please?
Thanks
Solved! Go to Solution.
@bptyates , if you add any other column in visual, other than one you selected in rank, the rank will inside that one
You are using 'Ames Sales'[Material] and you add 'Ames Sales'[Material ID] , then you rank will inside 'Ames Sales'[Material ID], all 1 . Only 1 material inside id
there we add both column, in rank all . or use table
example
Sales Ranking = RANKX(
AlL('Ames Sales'[Material], 'Ames Sales'[Material ID]),
[Invoiced Sales],,
DESC,
Dense
)
or
Sales Ranking = RANKX(
AlL('Ames Sales'),
[Invoiced Sales],,
DESC,
Dense
)
Also, check
Power BI Rank Across dimension tables: https://youtu.be/X59qp5gfQoA
@bptyates , if you add any other column in visual, other than one you selected in rank, the rank will inside that one
You are using 'Ames Sales'[Material] and you add 'Ames Sales'[Material ID] , then you rank will inside 'Ames Sales'[Material ID], all 1 . Only 1 material inside id
there we add both column, in rank all . or use table
example
Sales Ranking = RANKX(
AlL('Ames Sales'[Material], 'Ames Sales'[Material ID]),
[Invoiced Sales],,
DESC,
Dense
)
or
Sales Ranking = RANKX(
AlL('Ames Sales'),
[Invoiced Sales],,
DESC,
Dense
)
Also, check
Power BI Rank Across dimension tables: https://youtu.be/X59qp5gfQoA
Sorry, im not sure I understand, I dont have 'Ames Sales'[Material ID] in my data.
But the second option worked - thank you.
Check out the November 2023 Power BI update to learn about new features.