Show rows in table between 25th and 75th percentiles of a given measure

[Anonymous]

Hello All, I am familiar with TopN filter on a visual, but how could I filter in between ranked measures.

IE I have a table visual that has facility as rows and a Value called Measure. I want to show just the facilites that fall outside the 25th percentile and before the 75th percentile.  Or for simpler I could do facilities which measures fall out the top 5 and before the bttom 5.

[v-chenwuz-msft · Accepted solution]

Hi @Anonymous ,

I have created some data

Try this measure:

value_measure =
VAR _25 =
    PERCENTILEX.INC ( ALLSELECTED ( 'Table' ), [Values], 0.25 )
VAR _75 =
    PERCENTILEX.INC ( ALLSELECTED ( 'Table' ), [Values], 0.75 )
RETURN
    CALCULATE (
        SUM ( 'Table'[Values] ),
        FILTER ( 'Table', [Values] >= _25 && [Values] <= _75 )
    )

Then the result:

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

If needed, check if these can help

https://blog.enterprisedna.co/implementing-80-20-logic-in-your-power-bi-analysis/
https://forum.enterprisedna.co/t/testing-the-pareto-principle-80-20-rule-in-power-bi-w-dax/459