Forum Discussion
freginier
Solution Sage
Solution SageKeep SUM despite filter
Dear all,
I try to get the sum of all rows (filtered on range date) like this :
But when I try to filter on product to only display product C for example I got total equal C value..
My Measure :
total = CALCULATE( sum('PRODUCT'[PRODUCT_VALUE]), ALLEXCEPT('TRANSACTION','TRANSACTION'[DATE]) )
How can I keep total (filtered on date) on all rows even filtered ?
thank you !
2 Replies
- amitchandak
Super User
freginier , Based on what I got
if(isinscope('PRODUCT'[PRODUCT_ID]),sum('PRODUCT'[PRODUCT_VALUE]), CALCULATE( sum('PRODUCT'[PRODUCT_VALUE]), ALLEXCEPT('TRANSACTION','TRANSACTION'[DATE]) ))
IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM
freginierThank you amitchandak but still not working for me, I have the same result.
This is the power bi file : https://we.tl/t-mCkzArcfyv
