Jaco1965Frequent Visitor7 years agoSolvedMeasure Column does not Total correctI need the Total to add the Column value, please help MFelix to Jaco19657 years agoHi Jaco1965 , In my measure I use the ";" as a separator this is related with regional settings, change it by "," and see if you are abble to use the measure. Total_Inv_value = SUMX(Work_Detail , [Inv_Amnt]) Regards, MFelix
MFelix to Jaco19657 years agoHi Jaco1965 , In my measure I use the ";" as a separator this is related with regional settings, change it by "," and see if you are abble to use the measure. Total_Inv_value = SUMX(Work_Detail , [Inv_Amnt]) Regards, MFelix
MFelix to Jaco19657 years agoHi Jaco1965 , In my measure I use the ";" as a separator this is related with regional settings, change it by "," and see if you are abble to use the measure. Total_Inv_value = SUMX(Work_Detail , [Inv_Amnt]) Regards, MFelix
13 RepliesReplies sorted by Most LikedMFelixSuper User7 years agoHi Jaco1965 , Being you measure a multiplication of values you need to use a SUMX formula should look something like this: Inv_Amnt = SUMX(Work_Detail; Work_Detail[Work_Hrs] * R_ClassRate[Rate]) Be awar that you may need to adjust the parameters of the measure. Regards, MFelixJaco1965Frequent Visitor to MFelix7 years ago I am still doing something wrong Jaco1965Frequent Visitor to MFelix7 years ago I also tried this Jaco1965Frequent Visitor to MFelix7 years agoSome more info I use the 2 tables to calculate a measure, the red one. But i do need the totals to show correct below the table Jaco1965Frequent Visitor to Jaco19657 years agoI also tried this Show More
MFelixSuper User7 years agoHi Jaco1965 , Being you measure a multiplication of values you need to use a SUMX formula should look something like this: Inv_Amnt = SUMX(Work_Detail; Work_Detail[Work_Hrs] * R_ClassRate[Rate]) Be awar that you may need to adjust the parameters of the measure. Regards, MFelix
Jaco1965Frequent Visitor to MFelix7 years agoSome more info I use the 2 tables to calculate a measure, the red one. But i do need the totals to show correct below the table
Related contentMeasure two columnsCorrecting DataMeasure Total not correctDax correctionDax Formula correction help
