table doesn't take filter into account

[CLCastroEn]

Hello everyone!

I am working on a BI that has SKUs, also a column called "Status Salas" that has the values : Ok, Critical, Medium and Low which is with respect to each SKU and another column that is Sell 2019 and 2020 of each product.

to this you create a measure that is THE variation so : variation so s SUM(2020)- SUM(2019) / SUM(2019)

WHEN YOU LOOK AT THE TABLE IT LOOKS LIKE THIS :

where when I check the so variation of each status you can see that it correctly gives its percentage. But when I want growth with a filter that selects the 3 status gives me another value. In the total table you can see that the sum of 2019 and 2020 is not the same if we make it manual, so growth is taking bad inputs.

Should I use the calculate function? Please help

[Icey]

Hi @CLCastroEn ,

Please share us a dummy .pbix file with the same issue and the same data structure of your real data. Please remove sensitive information.

Best Regards,

Icey