Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Visual extremely Slow Load

Hi,   I have 2 tables Table A Equipment Parent Code GSC0B 107428 107501 GSC0V 107428 107500 GSC7S 107503 107504 GSCA3 107508 107506 GSCAE 107499 107498 GSCBD 107...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi Anonymous 

 

You may try this measure. I hope it will perform faster. 

Flag = 
var _a = VALUES('Table B'[Equipment])
var _b = CALCULATETABLE(VALUES('Table A'[Code]),ALL('Table A'),'Table A'[Equipment] IN _a)
return
IF(SELECTEDVALUE('Table A'[Parent]) IN _b, 1, 0)

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.