Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
@rssilvaba - Adding that measure to the visual returns 1 for every row. Where is "Goal"?
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.
@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...
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |