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.
I can´t get the right subtotal when using MAX as you can see below.
I need that TOTAL VENTAS adds one time the value of each row. i try using this:
Measure = CALCULATE(SUMX(GVA12;[MAX IMPORTE VENTAS]);VALUES(GVA12[CPTE VENTAS]);FILTER(GVA12;GVA12[T_COMP]<>"REC"))
but the result is the same that using TOTAL VENTAS.
The expected subtotal is -526.560,04
i´ll appreciate your help
Thanks
@arielacosta_ar,
Would you please share raw data of your table and post the formula you use to create the MAX IMPORTE VENTAS measure?
Regards,
Lydia
Probably has something to do with this issue:
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |