Forum Discussion
DAX Synex EARLIER Error
Hi Amos_Lim,
Please try using this DAX measure.
Rank =
RANKX(
FILTER(
'ForkLiftData',
'ForkLiftData'[SAP Number] = SELECTEDVALUE('ForkLiftData'[SAP Number])
),
'ForkLiftData'[ForkLift Name],
,
ASC
)
๐ I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
๐ก Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
๐ As a proud SuperUser and Microsoft Partner, weโre here to empower your data journey and the Power BI Community at large.
๐ Curious to explore more? [Discover here].
Letโs keep building smarter solutions together!
It gives and error message
A single value for column 'ForkLift Name' in table 'ForkLiftData' cannot be determined. this can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count or sum to get a single result
- grazitti_sapna1 year ago
Super User
Could you please share sample data, along with your expected result and any relevant logic.
If possible, upload a simplified .pbix file using this guide:
- Amos_Lim1 year ago
Resolver I
- Ashish_Mathur1 year ago
Super User
Hi,
Show the expected result in another column of the Excel file.