How to sum one column based on another column, but keep filter selection applied on table?

Anonymous — Fri, 23 Sep 2022 05:40:18 GMT

I have a table, and a set of slicers that filter the table.

Currently, I am using the "customers" slicer to filter the "billing account name" column.
I want to display the "ecom source name" with the highest number of "total duitable shpmts" in another advanced card visualisation. To do that, I need to sum up the "total duitable shpmts" column for the same "ecom source name"s. (eg. emailship should show total of 4+2=6, and ecom should show total of 4+1=5)

I have seen solutions using ALLEXCEPT, and I have tried using the following measure (shown in the last column of visualisation)

App Version Sorted Total Duitable Shpmts Col = var VarId= 'CIN Data Quality'[Ecom Source Name] return CALCULATE(SUM([Total Dutiable Shpmts]), FILTER('CIN Data Quality','CIN Data Quality'[Ecom Source Name]=VarId))

But I am getting results that are disregarding the values for "billing account name" a.k.a "customers" in the filter selection.

Re: How to sum one column based on another column, but keep filter selection applied on table?

amitchandak — Fri, 23 Sep 2022 08:43:54 GMT

Anonymous , Try Like

CALCULATE(SUM([Total Dutiable Shpmts]), FILTER(allselected('CIN Data Quality'),'CIN Data Quality'[Ecom Source Name]=Max('CIN Data Quality'[Ecom Source Name])))

Re: How to sum one column based on another column, but keep filter selection applied on table?

Anonymous — Fri, 23 Sep 2022 09:10:31 GMT

You're an expert! Thank you so much! 👍

topic How to sum one column based on another column, but keep filter selection applied on table? in DAX Commands and Tips

How to sum one column based on another column, but keep filter selection applied on table?

Re: How to sum one column based on another column, but keep filter selection applied on table?

Re: How to sum one column based on another column, but keep filter selection applied on table?