Forum Discussion

LotteLaugesen's avatar
LotteLaugesen
Icon for Helper V rankHelper V
4 years ago
Solved

SELECTEDVALUE 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 ...
SELECTEDVALUE
  • LotteLaugesen's avatar
    LotteLaugesen
    4 years ago

    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 
     

Mikelytics's avatar
Mikelytics
Icon for Resident Rockstar rankResident Rockstar
4 years ago

LotteLaugesen 

 

Can you please try this

 

CALCULATE(SUM(FT_StockTransactionsDetailed[Kg]),ALL(Dim_Items[Item Type]),Dim_Items[Item Type]="Waste")

 

or

 

CALCULATE(SUM(FT_StockTransactionsDetailed[Kg]),ALL(Dim_Items),Dim_Items[Item Type]="Waste")

 

________________________

If this post helps, then please Accept it as the solution to help other community members find it more quickly

Click on the Thumbs-Up icon if you like this reply.

LotteLaugesen's avatar
LotteLaugesen
Icon for Helper V rankHelper V
4 years ago

Unfortunately it doesn't help...