Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
User | Count |
---|---|
134 | |
72 | |
71 | |
55 | |
54 |
User | Count |
---|---|
201 | |
95 | |
63 | |
62 | |
51 |