Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
bptyates
Frequent Visitor

Measure not working

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

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@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. 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.