Condition if value is in another table with measure

[vividarinda]

I have two tables with a one-to-many relationship on the child's id. The table has other columns including the columns I have depicted below.  The two tables are:

Master Error Limit
iderror	limit
D375A1380MWL/U clutch slip failure	10
D375A1500L0Clutch engaged double	10
D375A15E0MWT/M clutch slip failure	9
D375A15SAL1F clutch failure	8
D375A15SALHF clutch failure	7
D375A15SBL1R clutch failure	5
D375A15SBLHR clutch failure	10

Data Trend
unit	date	iderror	error
DT07865	2/12/2024	D375A1380MWL/U clutch slip failure	1
DT07865	2/13/2024	D375A1380MWL/U clutch slip failure	2
DT07865	2/14/2024	D375A1380MWL/U clutch slip failure	1
DT07865	2/12/2024	D375A1500L0Clutch engaged double	4
DT07865	2/13/2024	D375A1500L0Clutch engaged double	9
DT07866	2/4/2024	D375A1380MWL/U clutch slip failure	1
DT07866	2/5/2024	D375A1380MWL/U clutch slip failure	1
DT07866	2/6/2024	D375A1380MWL/U clutch slip failure	1
DT07866	2/25/2024	D375A1500L0Clutch engaged double	3
DT07866	2/26/2024	D375A1500L0Clutch engaged double	10

I want to create visualization TABLE or MATRIX based on Data Trend and Master Limit that returns YES if the COUNT Error from data Trend table exceeds the limit from Master Error Limit Table . How can I do this using with measure? Any help would be appreciated. Thank you so much. 

visual
unit	iderror	count error	remark
DT07865	D375A1380MWL/U clutch slip failure	4
DT07865	D375A1500L0Clutch engaged double	13	yes
DT07866	D375A1380MWL/U clutch slip failure	3
DT07866	D375A1500L0Clutch engaged double	10

[v-binbinyu-msft · Accepted solution]

Hi @vividarinda ,

Please try below steps:

1. create measure with below dax formula

Measure = SUM('Data Trend'[error])

Measure 2 =
VAR _a = [Measure]
VAR _b =
    SELECTEDVALUE ( 'Master Error Limit'[limit] )
RETURN
    IF ( _a > _b, "Yes" )

2. add  a table visual with fields and measure

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vividarinda]

Hi @v-binbinyu-msft ,

Brilliant, thanks! Thank you for the solution.