Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Thanks in advance!
Solved! Go to Solution.
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] )
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] )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |