Forum Discussion

Fsciencetech's avatar
Fsciencetech
Icon for Helper III rankHelper III
5 years ago

Dax Formula

Hi folks, Here I want to result with camparing two fields but getting error "A table of multiple values was supplied where a single value was expected" column = OSMSData[ComponentPartNumber] Meas...
Need Help
Fsciencetech's avatar
Fsciencetech
Icon for Helper III rankHelper III
5 years ago

Hi Phillp,

Please guide me, for misspart measure resultant single value, It should be only with filter. I don't want to max value of "ComponentPartNumber"

 

MissPart =
CALCULATE(
MAXX(OSMSData,OSMSData[ComponentPartNumber])
,
FILTER(OSMSData,
// ALLEXCEPT(OSMSData,OSMSData[MaxOsLastreplandate1])
OSMSData[OSMaterialRecoveryDate] = MAX(OSMSData[OSMaterialRecoveryDate])
&& NOT(ISBLANK(OSMSData[OSMaterialRecoveryDate]))
),
SUMMARIZE(OBFact_Current,OBFact_Current[CustomerDGKey]),SUMMARIZE(OSMSData,OSMSData[MaxOsLastreplandate1])
)
 
MaxOsLastreplandate1 = 
CALCULATE(MAX(OSMSData[OSLastReplanDate]),ALLEXCEPT(OSMSData,OSMSData[ComponentPartNumber]))
v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Fsciencetech 

Sorry, I didn't check any problems with the formula grammar.And I didn't know the expected result you want.

Where did you find the error,in the masure or in the calculated column?

Please check whether there is any abnormality in the use of the lookupvalue function in $Not expected to ship in month.

 

Best Regards,
Community Support Team _ Eason