Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
vnqt
Helper V
Helper V

Visual extremely Slow Load

Hi,

 

I have 2 tables

Table A

EquipmentParentCode
GSC0B107428107501
GSC0V107428107500
GSC7S107503107504
GSCA3107508107506
GSCAE107499107498
GSCBD107509105921
GSCC6107511107510
GSCFV107502107503
GSCIP107505107508
GSCJ5107507107499
GSCJW107428107509
GSCL2107428107511
GSCNZ107501107502
GSCSF107501107505
GSCZG107501107507
GSCZY107428107497
GSC1T107427340979
GSC7T107501107516
GSCAH107500107522
GSCBG107504107520
GSCCD107506107523
GSCEQ107498107524
GSCGX105921107517
GSCHI107510107526
GSCJN107427107515
GSCM9107427107514
GSCNF107427107513
GSCRU107427107512
GSCV0107519107521
GSCVV107525107519
GSCXV107518107525
GSCZT107427107518

 

Table B 

 

Equipment
GSC0B
GSC0V
GSC7S
GSCA3
GSCAE
GSCBD
GSCC6
GSCFV
GSCIP
GSCJ5
GSCJW
GSCL2
GSCNZ
GSCSF
GSCZG
GSCZY
GSC1T
GSC7T
GSCAH
GSCBG
GSCCD
GSCEQ

 

Table C

( Table A[Equipment] * -----1 Table C[Equipment]) 

EquipmentParentSizebrand
GSC0B10742812HP
GSC0V10742813DELL
GSC7S10750314HP
GSCA310750815DELL
GSCAE10749916HP
GSCBD10750917DELL
GSCC610751118HP
GSCFV10750219DELL
GSCIP10750520HP
GSCJ510750721DELL
GSCJW10742822HP
GSCL210742823DELL
GSCNZ10750124HP
GSCSF10750125DELL
GSCZG10750116HP
GSCZY10742817DELL
GSC1T10742718HP
GSC7T10750119DELL
GSCAH10750020HP
GSCBG10750421ASC
GSCCD10750622RVN
GSCEQ10749823VDE
GSCGX10592124DELL
GSCHI10751025HP
GSCJN10742725ASC
GSCM910742725RVN
GSCNF10742725VDE
GSCRU10742725DELL
GSCV010751925HP
GSCVV10752525ASC
GSCXV10751825RVN
GSCZT10742720VDE

There is a slicer with the name of Equipment (Table B) 

When a Equipment selected, here for example:  Equipment:  GSC0B in table A, the code is 107501, then I use this code to search in column Parent, the result is below but it takes like forever to load this table

Nom_EquipementParentCode_BarreSizebrand
GSCNZ10750110750224HP
GSCSF10750110750525DELL
GSCZG10750110750716HP
GSC7T10750110751619DELL

I use the following measure : 

 

Flag = 
var _a = ALLSELECTED('Table B'[Equipment])
var _b = SELECTCOLUMNS(FILTER(ALL('Table A'),[Equipment] in _a),"Code",[Code])
return IF(SELECTEDVALUE('Table A'[Parent]) in _b,1)

 

vnqt_0-1686577793563.png

 

Final output:

vnqt_1-1686577793728.png

 

 

 

Thank you in advance for any suggestion to reduce the loading time. 

Tg

2 REPLIES 2
v-jingzhang
Community Support
Community Support

Hi @vnqt 

 

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)

vjingzhang_0-1686720103356.png

 

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

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: 

 

vnqt_0-1686825051237.png

Here is the Relation of tables 

vnqt_1-1686825131364.png

Thank you for your help. 

Tg 

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.