Forum Discussion

setis's avatar
setis
Post Partisan
7 years ago
Solved

Help with a simple filter

Dear all,   I need help with a filter. As you can see here below Apples can bee 3 types.    I need to filter only one type but I still need the amount of the other fruits in the same column. The ...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    whats up setis

     

    I think what you have is probably not the best way to organize the data but you can try this as measure (eliminate the relationship or change the names, you now have Apple and Apples):

     

    AmountFruits(Apples only Gala) 2 =
IF (
    SELECTEDVALUE ( Sheet1[Fruit] ) = "Apples";
    CALCULATE ( SUM ( AmountType[Amount] ); AmountType[Type] = "Gala" );
    [TotalAmount]
)

     

     

AlB's avatar
AlB
Community Champion
7 years ago

whats up setis

 

I think what you have is probably not the best way to organize the data but you can try this as measure (eliminate the relationship or change the names, you now have Apple and Apples):

 

AmountFruits(Apples only Gala) 2 =
IF (
    SELECTEDVALUE ( Sheet1[Fruit] ) = "Apples";
    CALCULATE ( SUM ( AmountType[Amount] ); AmountType[Type] = "Gala" );
    [TotalAmount]
)