Forum Discussion
Solved
DAX formula
Dear All, I have the following two tables: TABLE1 CompanYName1 Amount€ ALPHA LLC 5.000 ACME INC 1.000 SOYLENT GREEN CORP 3.000 SLUDO LLC 4.000 XXX A SEXY HORROR COMPANY ...
gianmarco It should be if you use the same "__Company" column name. That's the reason to use SELECTCOLUMNS. I mocked it up and it seems to work. See attached PBIX below signature.
Hi gianmarco ,
Here are the steps you can follow：
1. Create measure.
Measure = var _table2=SELECTCOLUMNS('Table2',"1",[CompanYName2]) return SUMX(FILTER(ALL(Table1), NOT('Table1'[CompanYName1]) in _table2),[Amount€])2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
gianmarco Try:
Measure =
VAR __Table1 = SELECTCOLUMNS('TABLE1',"__Company",[CompanyYName1])
VAR __Table2 = SELECTCOLUMNS('TABLE2',"__Company",[CompanyYName1])
VAR __Result = COUNTROWS(EXCEPT(__Table2, __Table1))
RETURN
__Result
Dear Greg_Deckler
it says for every table argument of EXCEPT it must be the same column number which is not 😞
gianmarco It should be if you use the same "__Company" column name. That's the reason to use SELECTCOLUMNS. I mocked it up and it seems to work. See attached PBIX below signature.