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] ) )
DaneHowarth , Create a measure like
Reference Company Sales = CALCULATE(SUM(Table[Sales]),filter(allselected(A_Table), A_Table[Company]= max(Table[Reference Company])))
Awesome, thanks so much amitchandak
