Sum Filtered Values

[beanscruz]

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

[v-robertq-msft]

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.

[amitchandak]

@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.

[beanscruz]

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! 

[beanscruz]

Hi @amitchandak, here's the link to the file: https://cebupacificairph-my.sharepoint.com/:u:/r/personal/vincent_cruz_cebupacificair_com/Documents/... 

[v-robertq-msft]

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:

https://support.microsoft.com/en-us/office/share-onedrive-files-and-folders-9fcc2f7d-de0c-4cec-93b0-...

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]

Thank you! @v-robertq-msft