Forum Discussion
Solved
RANKX with table aggregation
Looking for help with the RANKX function, where table aggregation is required as an intermediate step. With a data table as illustrated below, I want to achieve a rank of Business Group based on th...
Hi,
I am not sure how your expected outcome looks like, but please check the below picture and the attached pbix file.
It is for creating a measure.
Rank by activity duration measure: = IF ( HASONEVALUE ( Data[Business Group] ), RANKX ( ALL ( Data[Business Group] ), CALCULATE ( SUM ( Data[Activity Duration] ) ), , DESC ) )
Hi,
I am not sure how your expected outcome looks like, but please check the below picture and the attached pbix file.
It is for creating a measure.
Rank by activity duration measure: =
IF (
HASONEVALUE ( Data[Business Group] ),
RANKX (
ALL ( Data[Business Group] ),
CALCULATE ( SUM ( Data[Activity Duration] ) ),
,
DESC
)
)
Thank you very much for your help!