Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all, I know this is probably quite simple, but I'm in a rush job and just can't figure it out! I need to list the Top 20 outstanding Dollar amounts based on whether there is a completed date or not.
First, I created a column that populates the word Blank if there is no Completed Date and NonBlank if there is a Completed Date.
Then I tried creating this measure
Solved! Go to Solution.
@SandeA hi, just select TOPN on the visual filter level and drop the column in By value field.
and then set column= Blank in filter level.
@jaipal - after a few failed attempts I finally got that to work! I always forget about the filter panel because its usually collapsed when I open the Desktop BI. Thank you!
@SandeA hi, just select TOPN on the visual filter level and drop the column in By value field.
and then set column= Blank in filter level.
User | Count |
---|---|
86 | |
82 | |
68 | |
65 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |