cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper IV
Helper IV

table doesn't take filter into account

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 :

CLCastroEn_0-1606323964357.png

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

1 REPLY 1
Community Support
Community Support

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

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors