Measure for multiplying Measure with a Table

[Anonymous]

Hi, 

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. 

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. 
To summarize: 
number of concultants X Average salary 

This is how the measure is looking: 

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. 
Best regards!

[FreemanZ]

how is your measure defined?

[Anonymous]

Antal konsulter = COUNTX('Total Forecast', 'Total Forecast'[Emp.no])

"Antal konsulter" means amount of consultants. This is the measure that is created. 

With this measure combined with "company" and "date" queries I created this: 

I want to create something similar but just by showing the "total salary = average salary x amount of cosultants

[Wilson_]

Hello,

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.

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.

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]

Hi! 

Sorry maybe did not use the right word. With table I mean this : 

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. 
So the number of consultants in january (For x country) x Average salary in january (For x country) 

Hope this can help! 

[Wilson_]

Hello,

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.

• What's your measure syntax?
• What's your calculated column syntax?

[Anonymous]

Don't really know what to answer you here. Sorry! But this is what I answered to a similar question up above. 

Antal konsulter = COUNTX('Total Forecast', 'Total Forecast'[Emp.no])

"Antal konsulter" means amount of consultants. This is the measure that is created. 

With this measure combined with "company" and "date" queries I created this: 

I want to create something similar but just by showing the "total salary = average salary x amount of cosultants

[Wilson_]

Can you provide a (sample) pbix? It sounds like there are a handful of tables involved.

[Anonymous]

This is det dax formula for the measure:
Amount of consultants = COUNTX('Total Forecast', 'Total Forecast'[Emp.no]) 
But I could maybe just create a new measure but start with the same formula. Ex: 

Total lönekostnad = COUNTX('Total Forecast', 'Total Forecast'[Emp.no]) * 

 COUNTX('Snittlönekostnad','Snittlönekostnad'[Snittlönekostnad])

That gives me this :

 

Not correct, but maybe I am on the right way. What do you think?