Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |