Forum Discussion

SandeA's avatar
SandeA
Icon for Helper III rankHelper III
4 years ago
Solved

Top20 Amounts

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 

OtstdnWrntAmts = CALCULATE (TOPN (20, OutstandingWarrants, OutstandingWarrants[Amount]), DESC), FILTER(OutstandingWarrants,OutstandingWarrants[ComplDateBlank]="Blank"))
 
but I'm getting this error message
"The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."
 
Please help! Thank you!
Need Help
  • jaipal's avatar
    jaipal
    4 years ago

    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. 

     

2 Replies

  • jaipal's avatar
    jaipal
    Icon for Resolver III rankResolver III
    4 years ago

    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. 

     

  • SandeA's avatar
    SandeA
    Icon for Helper III rankHelper III
    4 years ago

    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!