Forum Discussion
Calculate the Bottom N
Hey I am trying to calculate the bottom 3 posts by engagement rate and not sure how to go about it since there is no bottom dax measure just a TOPN one. I tried Bottom 3 posts = CALCUL...
Measure 1:
total engagement rate = SUM('Upfront Slides'[Upfront engagement rate])
Measure 2:
Bottom 3 N =
total engagement rate = SUM('Upfront Slides'[Upfront engagement rate])
Measure 2:
Bottom 3 N =
CALCULATE([total engagement rate],
FILTER(
'Upfront Slides',
VAR Ranked =
RANKX(
'Upfront Slides',
[total engagement rate],,
ASC,
Dense
)
RETURN
Ranked >= 2 && Ranked <=4
)
)
This worked for me in my dataset but I've replaced values with your tables. Hopefully it works for you too.
This worked for me in my dataset but I've replaced values with your tables. Hopefully it works for you too.
auduno This isnt working for me, I originally had it but it was only showing 2 posts and now its not working across anything. here is an example PBXI