Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, how are you?
I have a small problem with a formula.
I have a slightly extended base on which I am performing a margin test, everything was fine until I tried the following formula:
i.Margin = sumx ('Final ad base', 'Final ad base' [i.cmvv] + 'Final ad base' [i.vendas])
the result was this:
Clearly the result should not be this, could someone help me fix and explain what went wrong with the formula?
Best Regards
Hi,
If i.cmvv and i.vendas are columns (and not measures) in the Final ad base table, then this measure should work
='Final ad base' [i.cmvv] + 'Final ad base' [i.vendas]
Hope this helps.
Hi Ashish thanks for the answer!
Ok, i tried it and the result is the same, pretty strange no?
Reggards
Is your Fam_Item column on the same table with the columns you are SUMming? If not, what is the relationship between them?
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Yes, is the same file, it's only one base.
Farm_item is a classification of the items:
CMV another column with values;
R$ total is another column with values.
i tried sumx with calculate, tried also create a new column with SUMX Farm_item, tried do just the sum and still not working.
Best Reggard
Hi, @Sergiocampos
What is your expected result?
Can you show the value of the column'Final ad base' [i.vendas] in the screenshot?
In addition, please check if there is something wrong with the format of the measure i.Margin.
Best Regards,
Community Support Team _ Eason
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
98 | |
79 | |
64 | |
57 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |