Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I currently have a large table that requires a visualised index column. I have come across this EXAMPLE formula for a RANKX and FILTER for a new column in the table :
RANKX(
FILTER(
‘Sales Table’,
‘Sales Table'[Country ] = EARLIER(‘Sales Table'[Country ])
),
‘Sales Table'[Total Sales]
)
but I'm struggling to replicate it with my data:
Supplier Analysis Index Rank = RANKX(ALL('looker_views lkr_Intake_Data'[Supplier Group Name]),'looker_views lkr_Intake_Data'[Company_Id],,ASC)
Only filtered for:
'looker_views lkr_Intake_Data'[Intake_Data_Custom_1] in {"COP1","COP2"})
Can anyone help?
Sample data would be greatly helpful. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
7 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
10 |