Joining two table variables in a DAX measure

[elidman]

Hi forum!

I can't get the below query to work. Any help would be appreciated.

I have one table-variable containing all employees and their salary per month (and company, scenario, currency).

I have another temporary table containing the social cost% for each month, (and company, scenario,)

Now I would like to calculate the salary x social cost% to get the final social cost amount per employee.

Something like below.

Both temporary tables contains the expected rows and columsn with data.

But the join doesn't work. The salary comes back, but no social cost%

Any idea? 

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

Calc Social Cost =

VAR tempSalaryCostTable =

    SUMMARIZE (

        FactPlanningData,

        FactPlanningData[CompanyKey],

        FactPlanningData[ScenarioKey],

        FactPlanningData[DateIntKey],

        FactPlanningData[EmployeeKey],

        FactPlanningData[CurrencyKey],

        "Calc Salary Cost", [Calc Salary Cost]

    )

VAR tempSocialFeeTable =

    SUMMARIZE (

        FactPlanningData,

        FactPlanningData[CompanyKey],

        FactPlanningData[ScenarioKey],

        FactPlanningData[DateIntKey],

        "Calc Plan Social Fee%", [Plan Social Fee%]

    )

var tempCalcTable = NATURALINNERJOIN(tempSalaryCostTable, tempSocialFeeTable)

VAR SocialCost =

    SUMX (

        tempCalcTable, [Calc Salary Cost] * [Calc Plan Social Fee%]

    )

RETURN SocialCost

-----------

[elidman]

Hi Greg,

Why should I try to convert anything to CSV? Sorry, I dont get it?

/Erik

[Greg_Deckler]

@elidman First, use TOCSV to ensure that you are getting "Calc Plan Social Fee%" values in your tempSocialFeeTable variable.