Forum Discussion
Syndicate_Admin
Administrator
AdministratorProblem with totals in measurements
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
1 Reply
- Ritaf1983
Super User
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
