Forum Discussion

Nabil20_24's avatar
Nabil20_24
Icon for Helper I rankHelper I
2 years ago
Solved

Island Table

Hi All,    I have the table below as well as other tables, the relationship between this table and the other tables is 1 to *; I created calculated coulmn in the below table and called maskedcountr...
Need Help
Tips and Tricks
  • muhammad_786_1's avatar
    muhammad_786_1
    2 years ago

    Hi Nabil20_24 

     

    I just created a DisplayedName measure instead of a calculated column and it worked perfectly.

     

     

    I've also attached a link to a reference file. You can check it out as well.

     

    File


    Best Regards,
    Muhammad Yousaf

     

    If this post helps, then please consider "Accept it as the solution" to help the other members find it more quickly.

     

    LinkedIn

     

Sahir_Maharaj's avatar
Sahir_Maharaj
Icon for Super User rankSuper User
2 years ago

Hello Nabil20_24,

 

Can you please try this revised version:

DisplayedName = 
IF(
    SELECTEDVALUE(MaskTable[Mask], "Masked") = "Unmasked",
    MAX('Data'[Country Name]),
    MAX('Data'[MaskedName])
)
Nabil20_24's avatar
Nabil20_24
Icon for Helper I rankHelper I
2 years ago

Hi Sahir, 

 

Thanks for this. Actually max will return one row only