Forum Discussion
Ranking Cumulative Total
I see what I did, the ALL needs to be ALL ( Table[column] ) not just ALL ( Table). So using the Contoso DB:
We have colors on rows, so that is the inital filter context. Have a measure to count the # of products from the products table. So with colors on rows, we will get the amount of products filtered by the color.
Base Measure:
Total Products = COUNTROWS('Product')Rank Measure:
RANK = RANKX( ALL( 'Product'[Color]), [Total Products])Using ALLSELECTED will give a "local" rank vs. a "global" rank of using ALL:
RANK Using AllSelect = RANKX( ALLSELECTED( 'Product'[Color]), [Total Products])
The data I am working is unfortunately confidential and I would be breaching my company's external data sharing policy.
I'm only using one table with a quantity amount column and text-based part number column.
I see what I did, the ALL needs to be ALL ( Table[column] ) not just ALL ( Table). So using the Contoso DB:
We have colors on rows, so that is the inital filter context. Have a measure to count the # of products from the products table. So with colors on rows, we will get the amount of products filtered by the color.
Base Measure:
Total Products = COUNTROWS('Product')Rank Measure:
RANK =
RANKX(
ALL( 'Product'[Color]),
[Total Products])
Using ALLSELECTED will give a "local" rank vs. a "global" rank of using ALL:
RANK Using AllSelect =
RANKX(
ALLSELECTED( 'Product'[Color]),
[Total Products])Thanks Nick, I found out the reason behind why it was originally showing in order, I had negative quantities in my table that were being calculated in the ranking and that I needed to filter within the report. I appreciate the help.