Forum Discussion
IF Statement - Two tables - No relationship - Help needed!
Hi Anonymous ,
Please update the formula of your calculated column as below:
new column =
VAR _count =
COUNTX (
FILTER (
'membership_package',
1 = 1 //please add the proper condition here
&& 'appended_table'[lwin11_count] > 'membership_package'[annual_data_allowance]
),
'appended_table'[lwin11_count]
)
RETURN
IF ( _count > 0, "Exceeded", "Within Limit" )If the above one is not working, please provide the relationship fileds which these four tables created the relationship base on and some sample data (exclude sensitive data) from them. And 'appended_table'[lwin11_count] and'membership_package'[annual_data_allowance] is a one-to-one relationship, that is, one 'appended_table'[lwin11_count] corresponds to only one'membership_package'[annual_data_allowance] value? It is better if you can provide your sample pbix file(exclude sensitive table) if it is convenient. Thank you.
Best Regards
Hi Anonymous ，
Please create a calculated column as below to get it, you can find the details in the attachment.
Column =
VAR _midmp = 'appended_table'[m_id]
VAR _mercid =
CALCULATE (
MAX ( 'merchant_group'[merchant_id] ),
FILTER ( 'merchant_group', 'merchant_group'[m_id] = _midmp )
)
VAR _prefvalue =
CALCULATE (
MAX ( 'merchant_broker_pref'[pref_value] ),
FILTER ( 'merchant_broker_pref', 'merchant_broker_pref'[mg_id] = _mercid )
)
VAR _ada =
CALCULATE (
MAX ( 'membership_package'[annual_data_allowance] ),
FILTER (
'membership_package',
FORMAT ( 'membership_package'[id], "#" ) = _prefvalue
)
)
RETURN
IF (
_ada = BLANK (),
BLANK (),
IF ( 'appended_table'[lwin11_count] > _ada, "Exceeded", "Within Limit" )
)
Best Regards
Thank you so much Anonymous, you the best!