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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you for your reply. Could you please share pbix cause I can't reproduce the same effect with your measure. 

     

    Here is the screenshot with 2 measure : Flag 1 and Flag 2 ( your suggested measure)

    There is no result with second flag measure: 

     

    Here is the Relation of tables 

    Thank you for your help. 

    Tg