Show not TOP5 but TOP6-10 results, based on a calculated value

[Barendnu]

Hi all,

We have a couple of graphs in which we show the top10, but that shows a lot of data in one graph.

Is there a way to show this in two separate visuals (visual1: 1to5, visual2: 6to10)?

Our graph uses a measure to calculate % positive: 

%_Positive = CALCULATE(COUNT(Sample[Respondent]); Sample[ScaleAnswer] > 5)/CALCULATE(count(Sample[Respondent]))

Currently, we use the built in topN filter to show only the top10:

This works perfectly, but because of the limited screen size we'd like to split this in two graphs.

So top5 in one graph, and the remaining items of the top10 in another graph.

I already played around with dax TOPN and RANKX, but could not get it to work combined with our %_Positive measure. See sample .pbix here: http://www3.e-research.nl/images/PowerBI/SampleTopN.pbix. Any suggestions would be greatly appreciated!

[Zubair_Muhammad · Accepted solution]

@Barendnu

Try using this MEASURE as VISUAL filter.

See file attached as well

RANK =
RANKX ( ALLSELECTED ( 'Sample'[Subject] ), [%_Positive],, DESC, SKIP )

[Barendnu]

Thanks for the good and fast answer!

In our 'real' setup, we had another related table that provided the legend items in the graph, so I added a CALCULATE + ALL to combine the ranking of all legend items combined:

RANK = RANKX(ALLSELECTED('Sample'[Subject]);CALCULATE([%_Positive];ALL('Legend items'[Legend item value]));;DESC;Skip)

Works like a charm now 🙂