Problem with totals in measurements

[Syndicate_Admin]

Hello good day I am having a problem with the totals of a measure, I have implemented the following formula:

Lbs Proyec Resp. Text = var _Resp1=SUMMARIZE(BaseText2,BaseText2[Color],BaseText2[SupplierReal],"_Valor1",[lbs Proyec Resp Textilera])

RETURN IF(HASONEVALUE(BaseText2[Color]),[lbs Proyec Resp Textilera],SUMX(_Resp1,[_Valor1]))

But the value of the total is still wrong

I have applied the same formula principle in other columns and in these it does work correctly, so it seems to me that the problem is occurring when it finds a value in 0

In the image I have marked 2 columns in green where the formula is applied but it has a data at zero and returns an incorrect value, while the one marked in yellow works without problem

I will appreciate it if you help me to orient myself to a solution

[Ritaf1983]

Hi @Syndicate_Admin 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly