Forum Discussion
LotteLaugesen
Helper V
Helper VSELECTEDVALUE in calculation not working
Hi I have a filter this filter: and I'm trying to do a calculation depending the selected Item Type Calculation no 1 is working fine and gives me the correct result, but no 2 and 3 are ...
Thank you for asking 😊
Because then I came to the thought that I have removed the interaction between the filter and report 🙄 - stupid me and sorry
VahidDM
Super User
Super User
Try these 3:
1. CALCULATE(SUM(FT_StockTransactionsDetailed[Kg]),Filter(All(Dim_Items),Dim_Items[Item Type]="B-Grade"))
2. Dim_Items
3. SUM(FT_StockTransactionsDetailed[Kg]) -- IF there is a relationship between "FT_StockTransactionsDetailed" and "Dim_Items", when you select an item on slicer, that will filter the connected table as well.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
LotteLaugesenHelper V
Helper VThank you for answering, but it was me that made a mistake, so I close the case