Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
So I have the following calcluation to rank items that are sold by the invoicved amount and it works fine.
Product Running Total =
[Total Inv Amount],,
I have added more data to my report and created a second version:
Sales Ranking = RANKX(
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?
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
Sales Ranking = RANKX(AlL('Ames Sales'[Material], 'Ames Sales'[Material ID]),[Invoiced Sales],,DESC,Dense)
Sales Ranking = RANKX(AlL('Ames Sales'),[Invoiced Sales],,DESC,Dense)
Power BI Rank Across dimension tables: https://youtu.be/X59qp5gfQoA
View solution in original post
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.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.