Forum Discussion
Syndicate_Admin
Administrator
3 years agocolumn with IF order, total incorrect
Hello I have reviewed the posts on similar topics, but no solution suits what I need. I would appreciate assistance with this formula. I have a column (measure) and at row level the result is correct...
Anonymous
3 years agoNot applicable
Hi Syndicate_Admin ,
Due to I don't know your table and data model, here I will give you some suggestions.
1. Is [prov po + model] a condtional column like [Reference Comm]?
If "Yes", I suggest you to use summarize() in SUMX() table field.
2. Does [prov po + model] come from the same table as [Reference Comm]?
If "Yes", meausure should look like as below.
New Units prov Recibidas 2 =
SUMX (
SUMMARIZE (
'TableName',
'TableName'[Reference Comm],
'TableName'[prov po + model]
),
[Units prov Recibidas 2]
)
If "No", add [prov po + model] based on your data model.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Syndicate_Admin
Administrator
3 years agoThank you very much¡¡¡ It has worked perfectly.