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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

check value with condition in another table

Hi,

 

my first table looks like:

Group   account_from      account_to      size_from    size_to    
A100900  
B  3040
C    

 

my second table is

account    size    
735
2287
250100

 

output should be

account      size     Group     
735Bbecause, 35 is between 30-40
2287Cbecause, 22 is not between 100-900 and not between 30-40
250100Abecause, 250 is between 100-900

 

Any idea how I can do this with DAX? 🙏

 

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

It is for creating a calculated column.

 

Jihwan_Kim_0-1721842559379.png

 

 

Group Calculated Column =
VAR _accountcondition =
    FILTER (
        'group',
        'group'[account_from] <= account[account]
            && 'group'[account_to] >= account[account]
    )
VAR _sizecondition =
    FILTER (
        'group',
        'group'[size_from] <= account[size]
            && 'group'[size_to] >= account[size]
    )
VAR _nocondition =
    FILTER (
        'group',
        'group'[account_from] = BLANK ()
            && 'group'[size_from] = BLANK ()
    )
RETURN
    SWITCH (
        TRUE (),
        COUNTROWS ( _accountcondition ) > 0, MAXX ( _accountcondition, 'group'[Group] ),
        COUNTROWS ( _sizecondition ) > 0, MAXX ( _sizecondition, 'group'[Group] ),
        MAXX ( _nocondition, 'group'[Group] )
    )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

View solution in original post

2 REPLIES 2
Jihwan_Kim
Super User
Super User

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

It is for creating a calculated column.

 

Jihwan_Kim_0-1721842559379.png

 

 

Group Calculated Column =
VAR _accountcondition =
    FILTER (
        'group',
        'group'[account_from] <= account[account]
            && 'group'[account_to] >= account[account]
    )
VAR _sizecondition =
    FILTER (
        'group',
        'group'[size_from] <= account[size]
            && 'group'[size_to] >= account[size]
    )
VAR _nocondition =
    FILTER (
        'group',
        'group'[account_from] = BLANK ()
            && 'group'[size_from] = BLANK ()
    )
RETURN
    SWITCH (
        TRUE (),
        COUNTROWS ( _accountcondition ) > 0, MAXX ( _accountcondition, 'group'[Group] ),
        COUNTROWS ( _sizecondition ) > 0, MAXX ( _sizecondition, 'group'[Group] ),
        MAXX ( _nocondition, 'group'[Group] )
    )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.
Anonymous
Not applicable

AWESOME! Thanks so much for your help. It works 😊

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.