Measure for multiplying Measure with a Table

Question

Hi,&nbsp;Would really appreciate some help here since I don't find a way to solve this. Please tell me if you need more information than what I tell you down below.&nbsp;I have a measure which is showing the amount of consultants ( categorized for each country) for every month. I want to use this measure to multiply with a table that I have created. This table shows the average salary for each countries consultants for every month.&nbsp;To summarize:&nbsp;number of concultants X Average salary&nbsp;This is how the measure is looking:&nbsp;The numbers shows how many consultants there are for each country for every specific month. I have crossed over with a red marker the companies/countries names.&nbsp;Best regards!

wilson_ · Answer

Hello,&nbsp;What do you mean by "multiply with a table"? Do you mean you have a table in your data model in the same format and you want to multiple corresponding cells together? If so, that's not possible per se (at least not the same way you would do it in Excel), because a measure is simply a calculation that returns a value, given your initial filter context.&nbsp;It's probably still possible in a different way though, if you're trying to put the result into a visual. However, that would depend on your data model.&nbsp;Can you please clarify if my understanding is correct and provide a pbix file?----------------------------------If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

anonymous · Answer

Hi!&nbsp;Sorry maybe did not use the right word. With table I mean this :&nbsp;The word "snittlönekostnad" means "average Salary". So this table I want to multiply with an already created measure that is made in the samy way, but instead of showing the average salary, it shows the amount of consutants.&nbsp;So the number of consultants in january (For x country) x Average salary in january (For x country)&nbsp;Hope this can help!&nbsp;

wilson_ · Answer

Hello,&nbsp;It likely will not work with your existing measure. When you are adding a calculated column, you have a row context but no filter context; when you create a measure you have a filter context but no row context.&nbsp;What's your measure syntax?What's your calculated column syntax?