Bottom N issue

Question

Hey&nbsp;&nbsp;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&nbsp;When I change it to Bottom 3 it shows only 1 post.&nbsp; Is this a glitch or am I doing something wrong?The formula is below just in case&nbsp;bottom posts = CALCULATE([Engagement Rate Measure] ,&nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; 'Content',&nbsp; &nbsp; &nbsp; &nbsp; VAR Ranked =&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RANKX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Content',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Engagement Rate Measure],,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ASC,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dense&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; RETURN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Ranked &gt;= 1 &amp;&amp; Ranked &lt;=4&nbsp; &nbsp; ))

ashish_mathur · Answer

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

anonymous · Answer

Ashish_Mathur&nbsp;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 · Answer

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

Forum Discussion

Bottom N issue

3 Replies

Related content

Averagex issue

Relationship Issue

SUMMARISECOLUMNS ISSUE

Bottom 10 considering repeated value.

Refresh issue