A table of multiple values was supplied when a single value was expected

[Anonymous]

Hi team,

I need some assistance, I'm getting this error message(A table of multiple values was supplied when a single value was expected) how can I fix these please. 

Here's the mesaure formula I created.

%Month =

DIVIDE(

SUM(NEW_Vehiclesnew[number]),

CALCULATE(

SUM(NEW_Vehiclesnew[number]),

REMOVEFILTERS(NEW_Vehiclesnew[fuel_type],NEW_Vehiclesnew[veh_type])

)

)

 

Second meaure: 

Month Loading =

DIVIDE(

SUM(NEW_Vehiclesnew[Contract_RV])-SUM(NEW_Vehiclesnew[exp_sp]),sum(NEW_Vehiclesnew[number])

)

If I run the code in SQL it retruns the full table.

[Fowmy]

@Anonymous 

Please check the measure  CHARM_NEW_Vehiclesnew[Quarter Loading] or share it here.
It is causes the error due to multiple values being returned.

[Anonymous]

Hi Fowny,

Thanks for the swift response. 

Quarter Loading =

CALCULATE(DIVIDE(

SUM(CHARM_NEW_Vehiclesnew[contract_rv]) - SUM(CHARM_NEW_Vehiclesnew[exp_sp]), SUM(CHARM_NEW_Vehiclesnew[aantal])),

REMOVEFILTERS(CHARM_NEW_Vehiclesnew[month_m]),

DATESINPERIOD(CHARM_NEW_Vehiclesnew[Date], DATEADD(CHARM_NEW_Vehiclesnew[Date], -2, MONTH), 2, MONTH)

)

[Anonymous]

Month Loading =

DIVIDE(

SUM(CHARM_NEW_Vehiclesnew[Contract_RV])-SUM(CHARM_NEW_Vehiclesnew[exp_sp]),sum(CHARM_NEW_Vehiclesnew[aantal])

)

Quarter Loading =

CALCULATE(DIVIDE(

SUM(CHARM_NEW_Vehiclesnew[contract_rv]) - SUM(CHARM_NEW_Vehiclesnew[exp_sp]), SUM(CHARM_NEW_Vehiclesnew[aantal])),

REMOVEFILTERS(CHARM_NEW_Vehiclesnew[month_m]),

DATESINPERIOD(CHARM_NEW_Vehiclesnew[Date], DATEADD(CHARM_NEW_Vehiclesnew[Date], -2, MONTH), 2, MONTH)

)

Year Loading =

CALCULATE(DIVIDE(

SUM(CHARM_NEW_Vehiclesnew[contract_rv]) - SUM(CHARM_NEW_Vehiclesnew[exp_sp]), SUM(CHARM_NEW_Vehiclesnew[aantal])),

REMOVEFILTERS(CHARM_NEW_Vehiclesnew[month_m]),

DATESINPERIOD(CHARM_NEW_Vehiclesnew[Date], DATEADD(CHARM_NEW_Vehiclesnew[Date], -1, YEAR), 1, YEAR)

)

[Fowmy]

@Anonymous 

Check the highlighted line where you have DATEADD. You need to provide a single value such as MAX(CHARM_NEW_Vehiclesnew[Date]). DATEDADD returns multiple valuues that's why you net an error.

If you can explain what exactly you are trying to calculate then, I will suggest the right solution.

[Anonymous]

Hi Fowmy,

Thanks once again.

What I am trying to calculate if by fule type on month, quater and year as in the image below. but the formula from the excel file is 

1. Issues below

 

Month=AL$43/$AA$43

Quarter: =SUM(AL$41:AL$43)/SUM($AA$41:$AA$43)--(SUM(AL$41:AL$43) to calulate the total number of vehicles per quarter / by the total number per quarter per fuel type SUM($AA$41:$AA$43

Year: =SUM(AL$32:AL$43)/SUM($AA$32:$AA$43) ( SUM(AL$32:AL$43 to calulate the total number of vehicles per month / by the total number per fuel type SUM($AA$32:$AA$43)

%Month =

DIVIDE(

SUM(CHARM_NEW_Vehiclesnew[aantal]),

CALCULATE(

SUM(CHARM_NEW_Vehiclesnew[aantal]),

REMOVEFILTERS(CHARM_NEW_Vehiclesnew[fuel_type],CHARM_NEW_Vehiclesnew[veh_type])

)

)

%Quarter =

DIVIDE(

CALCULATE(

SUM(CHARM_NEW_Vehiclesnew[aantal]),

REMOVEFILTERS(CHARM_NEW_Vehiclesnew[month_m]),

DATESINPERIOD(CHARM_NEW_Vehiclesnew[Date], DATEADD(CHARM_NEW_Vehiclesnew[Date], -2, MONTH), 2, MONTH)

),

CALCULATE(

SUM(CHARM_NEW_Vehiclesnew[aantal]),

REMOVEFILTERS(CHARM_NEW_Vehiclesnew[fuel_type],CHARM_NEW_Vehiclesnew[veh_type],CHARM_NEW_Vehiclesnew[month_m]),

DATESINPERIOD(CHARM_NEW_Vehiclesnew[Date], DATEADD(CHARM_NEW_Vehiclesnew[Date], -2, MONTH), 2, MONTH)

)

)

%Year =

DIVIDE(

CALCULATE(

SUM(CHARM_NEW_Vehiclesnew[aantal]),

REMOVEFILTERS(CHARM_NEW_Vehiclesnew[month_m]),

DATESINPERIOD(CHARM_NEW_Vehiclesnew[Date], DATEADD(CHARM_NEW_Vehiclesnew[Date], -1, YEAR), 1, YEAR)

),

CALCULATE(

SUM(CHARM_NEW_Vehiclesnew[aantal]),

REMOVEFILTERS(CHARM_NEW_Vehiclesnew[fuel_type],CHARM_NEW_Vehiclesnew[veh_type],CHARM_NEW_Vehiclesnew[month_m]),

DATESINPERIOD(CHARM_NEW_Vehiclesnew[Date], DATEADD(CHARM_NEW_Vehiclesnew[Date], -1, YEAR), 1, YEAR)

)

)

Please let me know if the above help to solve the problem