Top n results where n is based on a measure or expression

[rssilvaba]

Hi all, the following file has some sample data and in the table visual I am trying to display all the topn Urgent Items based on the "Total Number of Urgent requests"-"Goal" rounded up.

In the case of the current view in the sample that would be top 3 ordered from newest to oldest created date.

https://drive.google.com/file/d/1WFBlvVHV7cS4F519BP-UphHRPhNi4gtb/view?usp=sharing

[Greg_Deckler]

@rssilvaba - Adding that measure to the visual returns 1 for every row. Where is "Goal"?

[rssilvaba]

@Greg_Deckler "Goal" is the KPI Target Urgent Requests

[v-yingjl · Accepted solution]

Hi @rssilvaba ,

You can try this measure:

Goal = 
VAR top3 =
    COUNTX (
        TOPN ( 3, ALLSELECTED ( Requests[Created] ), 'Requests'[Created], DESC ),
        'Requests'[Created]
    )
RETURN
    top3 / [Total Number Urgent Requests]

Attached the modified sample file in the below, hopes to help you.

Best Regards,
Yingjie Li

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

[amitchandak]

@rssilvaba , see if this can help

https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...