Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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 the total activity duration associated with each Business Group. There are some duplicated Activity ID records in the data set to attribute multiple employees in some activity records.
I was thinking it involved a SUMMARIZE measure nested in the RANKX, but can't seem to get this working. Help appreciated.
Solved! Go to Solution.
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!