cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
setis Member
Member

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 desired result would be:
Apples 3, Oranges 5, Pears 6.  I hope that it makes sense. 

 

The file is here: https://drive.google.com/file/d/1XgZGlTbBpziV_FrQ5iQCAFtau5e-pcgK/view?usp=sharing  

 

fruits.PNG

 

Thanks in advance!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Help with a simple filter

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]
)

 

 

1 REPLY 1
Super User
Super User

Re: Help with a simple filter

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]
)