multiplication

[AYA97]

hello power BI community I hope you are doing good. so I'm a beginner on power BI desktop ,and I'm working on a report and I've been struggling since a while to achieve it. I have different columns from different tables and I would like to add a new columns which contain a the result of the multiplication between two different columns , I tried many methods and none was right ;I always have an error message. I verified the relations too and i think they are correct. So there are the different columns and the relations between them ,they all have the same designation ,so i will be grateful if you explain for me how to do it !

[amitchandak]

@AYA97 , I see multiple inactive joins, looking at data screenshot data model is not very clear

Example how can you mode data across table

Item Name = RELATED('item'[Brand])

Copy City without using related
City Name = maxx(FILTER(geography,geography[City Id]=Sales[City Id]),geography[City])

Using lookup

Month Name = LOOKUPVALUE('date'[Month Year],'date'[Date],Sales[Sales Date])

first and third expect a single value, so use some aggregation function if there are more than one value

[lbendlin]

your data model looks interesting.  What's the reasoning behind it? What do you think is your "facts" table?