Minimum sales value against category

[PrakashPalle]

Hi All,

I need lowest sales value vendor name wherever null present in vendor name column. 

Please share the dax expression for the below. Screen shot for your reference.

[ryan_mayu · Accepted solution]

@PrakashPalle 

is this what you want?

Column = MAXX(FILTER('Table','Table'[Sales]=EARLIER('Table'[Sales])),'Table'[Vendor Name])

[Ashish_Mathur]

Hi,

Cannot understand the input/output.  Do you need the result on a card visual?  Do you want the name and the price?  Share data in a format that can be pasted in an MS Excel file and show the expected result.

[PrakashPalle]

Hi @Ashish_Mathur , Thanks for the reply.

I need name & price in table format. 1st table actual data & 2nd is expected data.

[Ashish_Mathur]

Others are contributing.  They will help you.

[vicky_]

Hey, 
please try the following:

Vendor Name (no nulls) = IF(
    'Table (2)'[Vendor Name] = "", CALCULATE(MIN('Table (2)'[Vendor Name]), TOPN(1, ALL('Table (2)'), 'Table (2)'[Sales], ASC)), // find vendor with lowest sales
    'Table (2)'[Vendor Name] // just use the existing vendor name
)

Note - at the moment, the DAX will return the first vendor (alphabetically) in the case that there are two or more vendors with the same lowest sales. 

I recommend you take a look at the topN function documentation: https://learn.microsoft.com/en-us/dax/topn-function-dax