Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX statement does not see the table

Hi Guys !  I have got a simple problem, but for some reason under DAX it is not so simple. I have got two tables: i); all_ip_addresses,  ii); chosen_ip_addresses ii); Chosen ip addresses contai...
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    Try columns like below, this will check if there was any transaction in chosen_ip_addresses table related ( using active relationship ) to the table the column is in. 

     

    Column = 
CALCULATE(
    COUNTROWS( chosen_ip_addresses ) > 0 
)

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

     

  • Anonymous's avatar
    Anonymous
    6 years ago

    Ok Mariusz ! 

    I think I have figured it out.

    InfoColumn = if(CALCULATE(COUNTROWS(chosen_ip_addresses) > 0), RELATED(chosen_ip_addresses[Description]) , all_ip_addresses[Ip])

    This has solved my problem ! 
    Thank you for your time !! 

    Kind Regards,
    Bart
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

If what Mariusz says doesn't work you might try LOOKUPVALUE.