Forum Discussion
Solved
Filtering a result based on another column
Hi all I am looking for some help to figure out the DAX required to filter a column by another column. I have included some data below to illustrate the problem. In this example there are 3...
Hi DaneHowarth
Here is a sample file with the solution https://www.dropbox.com/t/T2GfvtNkOp8FqBl4Reference Company Sales = CALCULATE ( SUM ( A_Table[Sales] ), REMOVEFILTERS ( A_Table ), TREATAS ( VALUES ( A_Table[Reference Company] ), A_Table[Company] ) )
Hi DaneHowarth
I just noticed that my original solution deliveres correct results but wrong total. Here is the solution with the correct total https://www.dropbox.com/t/z9kBn81LzoPEG7Ex
Reference Company Sales =
SUMX (
SUMMARIZE ( A_Table, A_Table[Company], A_Table[Reference Company] ),
CALCULATE (
CALCULATE (
SUM ( A_Table[Sales] ),
REMOVEFILTERS(),
TREATAS ( VALUES ( A_Table[Reference Company] ), A_Table[Company])
)
)
)