@amitchandak it is difficult to share a example, because the dataset is very complicated with many joins and sensitive information etc. Maybe you can check the measure of "score", if there is something wrong. Otherwise I have to prepare some samples of the data. Here is the measure for the "score". The "score" is a classic weighted scoring model. The measure refers to one table. Score = -- definition weighting -- VAR price = 40 VAR punctuality = 25 VAR claim = 25 VAR goal = 10 -- Points for punctuality -- VAR points_of_punctuality = ([Average punctuality]*100)/ (CALCULATE (SUMX (VALUES(Data[Name]),[Average punctuality]), ALLSELECTED(Data) ) ) -- Points for claim -- VAR points_of_claim = (([Average claim])*100)/ ( ( (CALCULATE (SUMX (VALUES(Data[Name]),[Average claim]), ALLSELECTED(Data) ) ) ) ) -- Points for goal -- VAR points_of_goal = IF(Data[goal]<=7,100,50) -- Points for price -- VAR points_of_price = IF (CALCULATE (DISTINCTCOUNT(Data[Name])=1 && [Average price]<0, ALL(Data[Name]) ),100, IF(CALCULATE (DISTINCTCOUNT(Data[Name])=1 && [Average price]>0, ALL(Data[Name]) ),0, ([Average price]-[Max price])/(([Max price]-[Min price)/100)*(-1) ) ) -- Final Score with weighting -- VAR Final_Score = points_of_price*price+points_of_claim*claim+points_of_punctuality*punctuality+points_of_goal*goal RETURN Final_Score Thank you very much for your support!! Kind regards