Bottom N issue

[Anonymous]

Hey 

For some reason I always have issues with Bottom N. I want to look at bottom 3 but it only shows the 3 when I have the filter like this. All the metrics are completely different too so don't think it calls for me ranking them

When I change it to Bottom 3 it shows only 1 post.  Is this a glitch or am I doing something wrong?

The formula is below just in case

bottom posts = CALCULATE([Engagement Rate Measure] ,

    FILTER(

        'Content',

        VAR Ranked =

            RANKX(

                'Content',

                [Engagement Rate Measure],,

                ASC,

                Dense

            )

        RETURN

            Ranked >= 1 && Ranked <=4

    ))

[Ashish_Mathur]

Hi,

Do not use a Topn filter.  Just filter that column on <=3.  If it does not help, then share the download link of the PBI file.

[Anonymous]

@Ashish_Mathur could you explain this a bit more? I am trying to look at the bottom 3 posts based on engagement rate, I don't see the option for the filter you are talking about

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result very clearly.