March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
133 | |
91 | |
88 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
72 | |
68 |