Forum Discussion

Kashinoda's avatar
Kashinoda
Icon for Advocate I rankAdvocate I
4 years ago

Conditional statements within a CALCULATE filter

Hello, I have a simple measure which intersects my fact table with several disconnected tables and works without issue:   Intersect = VAR varInter1 = INTERSECT(ALL('Fact'[County]), VALUES ( 'Tr...
Need Help
Tips and Tricks
v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Kashinoda ,

I think the error is caused of the SWITCH function can't return a column or table, but only a value.

Best Regards,
Community Support Team _ kalyj