cancel
Showing results for
Did you mean:
Frequent Visitor

## Re: How to get Minimum price Supplier name?

No, i got an error while calculating 2nd formula i.e.

```VAR Suppliers =
CALCULATETABLE (
VALUES ( Trans[Supplier Name] ),
"SuppliedQty", CALCULATE ( SUM ( Trans[Qty] ) )
),
ALLEXCEPT ( Trans, Trans[Item Code] ),
Trans[Supplier Price] = MinPrice
)```

It is not working,  showing the below error.

The expression contains multiple columns, but only a single column can be used in a True/False expression that is used as a table filter expression.

Can you please recheck the solution in Power BI, I mean can you provide the solution screenshot.

And one thing i want to tell you, In my case supplier price( I mean one supplier price) will be same for all transactions for that item code

Eg: Supplier A supplied at \$1 for the item code 1001 . We may have 1000 transactions with supplier A for the item code 1001, but        he will supply at \$1 only.

Supplier C supplied at \$3 for the item code 1001. We may have 2000 transaction with supplier C for the item code 1001, but          he will supply at \$3 only.

Thank You

Regards

Nagarjuna

## Re: How to get Minimum price Supplier name?

Have fun with DAX!

Alberto Ferrari
http://www.sqlbi.com

Alberto Ferrari - SQLBI
Frequent Visitor

## Re: How to get Minimum price Supplier name?

Thank you @AlbertoFerrari

I made a mistake that's  why i got an error, sorry for that.

Now its worked without error but i got blanks in some rows (Almost in 50% rows). Can you Please tell me what could be the reason?

Thank you

Regards

Nagarjuna

## Re: How to get Minimum price Supplier name?

Without looking at the data? No way... Likely, there's a bug somewhere in the code, but I would need some test data to find it. If you can share some sample data where the errors spots, then I can take a look at it.

Have fun with DAX!

Alberto Ferrari
http://www.sqlbi.com

Alberto Ferrari - SQLBI
Highlighted
Frequent Visitor

## Re: How to get Minimum price Supplier name?

Thank you @AlbertoFerrari

Now its working, I changed formula according to my requirements.

Now i am checking with my report which i have done it in excel. If i found any deviations i will get back to you with the sample data, otherwise i will accept it as a solution.

Once again thank you so much

Regards
Nagarjuna

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 421 members 3,875 guests
Recent signins: