Hi, I need help with this measure, is not adding up correctly and I'm getting crazy, it has a lot of different dependancy from others measures, I'll explain all of them to give the full panoram. (Everything is in spanish for the name of the measures)
This is the issue, I have a matrix.
I'm adding the link to the file with the measures because some are long and this will become a Bible.
File with Measures
These are my results for January
| DESCRIPCIÓN | Vol_Ant(EQ) | Vtas_Ant($) | Vta/Vol(Ant) | Vol_Act(EQ) | Vtas_Act($) | Vta/Vol(Act) | SumEfectoVolTest | SumEfectoMixTest | SumEfectoPrice |
| ITEM XX | 20 | $5,398 | $266 | 10 | $4,016 | $391 | -$3,358 | $698 | $1,280 |
These are my results for February
| DESCRIPCIÓN | Vol_Ant(EQ) | Vtas_Ant($) | Vta/Vol(Ant) | Vol_Act(EQ) | Vtas_Act($) | Vta/Vol(Act) | SumEfectoVolTest | SumEfectoMixTest | SumEfectoPrice |
| ITEM XX | 25 | $6,793 | $270 | 8 | $3,181 | $391 | -$5,883 | $1287 | $983 |
When I selected individualy they work fine and the results are the expected, the issue comes when I select both months, my colums SumEfectoVolTest and SumEfectoMixTex start to get crazy and the measures doesn't match correctly.
| DESCRIPCIÓN | Vol_Ant(EQ) | Vtas_Ant($) | Vta/Vol(Ant) | Vol_Act(EQ) | Vtas_Act($) | Vta/Vol(Act) | SumEfectoVolTest | SumEfectoMixTest | SumEfectoPrice |
| ITEM XX | 45 | $12,190 | $536 | 18 | $7,197 | $782 | -$18,416 | $3,930 | $2,255 |
I was expecting something like this:
| DESCRIPCIÓN | Vol_Ant(EQ) | Vtas_Ant($) | Vta/Vol(Ant) | Vol_Act(EQ) | Vtas_Act($) | Vta/Vol(Act) | SumEfectoVolTest | SumEfectoMixTest | SumEfectoPrice |
| ITEM XX | 45 | $12,190 | $536 | 18 | $7,197 | $782 | -$9,247 | $1,985 | $2,255 |
They seems to double but I divide it by 2 and still doesn't match. What could be the issue? Or just powerbi can't work like that with measures?
