Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hi, Need Help.
I created a number of filters using only one main column in a table and i want to sum up those filtered values.
What can you recommend I should do to calculate this sum?
I'd like to add the costs (Numbers below) 1.1M + 76K + 4.5M +5.8M (this will be dynamic based on filter so i need to create a formula to execute this). Thank you in advance
Hi, @Anonymous
I tried to open the link you shared to download the pbix file, but I got an error message. It seems like I don’t have access to your SharePoint site. Would you like to check the link again?
Thanks very much!
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , if these numbers are based on different slicer/filter values and those are controlled on specific visual. Yes, you need to create a measure with a filter to get that.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi @amitchandak, thank you for your quick reply.
I can't seem to attach the pbix file. Do you have an email where i can send the sample? Thanks!
Hi @amitchandak, here's the link to the file: https://cebupacificairph-my.sharepoint.com/:u:/r/personal/vincent_cruz_cebupacificair_com/Documents/...
Hi, @Anonymous
You can upload the pbix file to Onedrive for business and share the download link in the Power BI community, you can follow this link:
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
| User | Count |
|---|---|
| 23 | |
| 22 | |
| 21 | |
| 18 | |
| 11 |
| User | Count |
|---|---|
| 56 | |
| 54 | |
| 43 | |
| 36 | |
| 34 |