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.
In this chart, the column .Dif_Valor (value difference) is a measure which multiply Variação*Vl_Vendas_Atual (variation* week sales). Variação is measured by (Marg_Atual)-(Marg_Ant) or (margin)-(last week margin).
What I need is for the column Dif_Valor to sum it's values and not make the calculation by lines. Can anyone help me?
Hi @TI_RB ,
Sorry, not very clear. What do you want to sum? Can you give an expected result. Does subtotal want to sum?
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @v-stephen-msft . I want to sum the subtotal of .Dif_Valor. Currently it's making a calculation by line.
Hi @TI_RB ,
The regular solution is to create a new measure and call the original measure.
New measure = SUMX('TABLE', [.Dif_Valor])
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Didn't work. Result value is 0.
Hi @TI_RB ,
Can you share pbix? If the data is private data, you can provide me with dummy data, measures you use and expected results.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |