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.
I have a graph which is based on a date and this measure
Yield = ('Put Away lines'[Number of Returned Boards] / 'Put Away lines'[Shipped Take Returned]) * 100
Number of Returned Boards = SUMX('Put Away lines','Put Away lines'[Quantity])
Shipped Take Returned = 'Shipment Lines'[Total Number Shipped] - 'Put Away lines'[Number of Returned Boards]
Total Number Shipped = SUM('Shipment Lines'[Quantity])
In my Bar chart if i filter for a specific value (Item) in this case this shows the correct figure.
However with no filter ( All items) the value is taking a sum of the average im guessing im not too sure.
Can anyone guide me on how to resiolve this. Thanks
HI @LewisH,
I think you formula works properly, when you use sum or other functions, it will auto summary by group label or column and also affected by filter/slicer.
For your requirement, you need to add some conditions to filter table to let your formula only work on current row contents instead all table.
Regards,
Xiaoxin Sheng
Hi do you have any suggestions on how I can do this?
HI @LewisH,
>>Hi do you have any suggestions on how I can do this?
Please share some sample data or pbix file to test.
Regards,
Xiaoxin Sheng
How can I share my pbix file with you?
HI @LewisH,
Upload to onedrive or google drive and share the link here.
Notice: please do mask on sensitive data before share.
Regards,
Xiaoxin Sheng
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |