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.
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, @beanscruz
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.
@beanscruz , 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, @beanscruz
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.
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 |
---|---|
108 | |
105 | |
87 | |
74 | |
66 |
User | Count |
---|---|
124 | |
112 | |
96 | |
80 | |
72 |