Get the name or the Top product from my count on sales

[Anonymous]

Hi I have 

the ProductcountMeasure  := 

CALCULATE( DISTINCTCOUNT( 'Sales'[SalesOrderNumber]) , 'Sales'[SalesOrderNumber] <> BLANK() )
then I have the the
dimProduct with the follow attributes (ProductCode, ProductDescription)
How can I get the ProductDescription of the product that appears on the top of my codes that appears in my Sales fact
I have the RankProduct := 

RANKX(ALL(Part[PartNumber]),[08 Count of SO Number])
That I can present in a Matrix.
But I would like to present in a card the first product of my rank

Thanks

Peter

[Anonymous · Accepted solution]

Hi @Anonymous ,

If you want to show ProductDescription of the product that appears on the top of your codes in card visual. I think you can add [RankProduct] in visual level filter and set it to show items when value = 1. Then you will get the ProductDescription of the product whose Rank =1.

Best Regards,
Rico Zhou

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

[rbriga]

You may use FIRSTNONBLANK with TOPN. 

See this post.