cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vanquisher11
Frequent Visitor

Formula/Calculation Help!!

Hi All,

Not sure if it's possible but I am trying to create a calculation where in I can view the average prices of each sub-type.

 

Condition:

-Table 1, 2, and 3 are connected together.

-All but one product is based on supplier 1 column. Tomatoes are based on supplier 2 column.

 

This is the visual that I want to show, but not exactly sure how to create a formula that would give me the correct values. It would have been easier if the they all have the same supplier just so that I can create a basic filter, but then it's complicated having multiple supplier column.

 

Many thanks,

 

Sub-TypeRoger + Roger/RafaRafa + Roger/Rafa
Lettucegb
Applesoe
Tomatoesas
Carrotstt

 

---------------------------------------------

Table 1: Product

TypeSub-Type
VegetablesCarrots
Fruits

Apples

FruitsMangoes
VegetablesTomatoes
VegetablesLettuce

 

Table 2: Supplier

Supplier 1 (All Products)Supplier 2 (Tomatoes Only)
RogerRafa
RafaRoger
Roger/RafaRoger/Rafa

 

Table 3: Price

Prices

5.50

3.20
1.16
3.14
1 REPLY 1
v-kelly-msft
Community Support
Community Support

Hi @vanquisher11 ,

 

It's a bit confused : 1. what does the letters in the table mean?

Annotation 2020-02-20 161022.png

2. How do the prices match the sub-category?

 

Best Regards,
Kelly
 
Did I answer your question? Mark my post as a solution!

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors