Island Table

[Nabil20_24]

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 maskedcountryname which shows Country 1 to 4 and then I created an island table which contains one column and two rows masked / unmasked. so what I am trying to do is that create a table visual which show either the name of the country or just the masked name as well as some columns pulled from the below table, measures created, and other columns from different table;  
this is my code but its not woking as when I change the option from the slicer the name of the country does not change 

MaskTable = DATATABLE(

    "Mask", STRING,

    {

        {"Masked"},

        {"Unmasked"}

    }

)

DisplayedName =

IF(

    SELECTEDVALUE(MaskTable[Mask], "Masked") = "Unmasked",

    'Data '[Country Name ],

    'Data '[MaskedName]

)

anyone cna tell me why this is not working the slicer seems to return what has been selected but the table I created does not change at all.

Country Name	Total Sales	Forecasted	Revenue	Budget
England	100	1000	5000	500
France	200	3500	3400	600
Germany	300	4400	1200	800
Spain	400	7600	6230	900

[muhammad_786_1 · Accepted solution]

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]

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]

Hi Sahir, 

Thanks for this. Actually max will return one row only