looking to show the new total value after remove the current item( or Product) weekly

[perezco]

Hi All , need some advice.
What Dax functions I can use if I am looking to show the new total value after remove the current item( or Product) weekly?

This will help me see if the item(product) is makinga possite or negative impact to the total value.

[Greg_Deckler · Accepted solution]

I'm thinking EXCEPT but very difficult to understand exactly what you are going for. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

That being said, perhaps the inverse aggregator? https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Aggregator/m-p/342266#M91

[perezco]

thanks.
it work... and yes EXCEPT  function is difficult... much more when you try to take that result and  try to use the function RANK