Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Problem with SWITCH formula

Hello   I try to write a SWITCH formula but it does not offer to autocomplete the table and column of my table when I enter the first parameter in the formula. It says: A single value for column ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak 

 

Thanks but I get this error:

The column 'SameTable[Col1]' either doesn't exist or doesn't have a relationship to any table available in the current context.

 

Any solution? 

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , it will work from 1-M direction. So change filter Table and related column

Try like

CALCULATE(COUNT(DifferentTable[Col1]),filter(SameTable,SameTable[Col1]=RELATED(DifferentTable[Col2])))