Forum Discussion

schapholkar's avatar
schapholkar
New Member
2 years ago

Slicer , Tile

I have a slicer Tile Style. I am using it to select countries. in the table there are many more countries then the list I am showing here.  when I click on Select All - I assumed it will show the re...
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi schapholkar ,

 

I would like to acknowledge the valuable input provided by the Bmejia . His initial ideas were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the issue.

 

In my investigation, I took the following steps:

 

Like you described in the topic, I created a table with 20 countries and a table with 10 countries.

 

I created a measure to check if the country/region from the original table exists in the new table.

 

Is SelectedCountry = IF(
    ISBLANK(RELATED('Country'[Country Name])),
    FALSE(),
    TRUE()
)

 

 

Use this measure as a page-level Filter and select it as True.

 

The effect of the page before applying the Filter is as follows:

 

The effect of the page after applying the Filter is as follows:

 

The pbix file is attached.

 

If you have any other queries please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

  • schapholkar's avatar
    schapholkar
    New Member
    2 years ago

    Hi 

    Many thanks for your quick reply -

    I have done exactly as per your advice  -

    1. below is my model view 

     

    Relationship created

    It is not allowing to commit due to below error

     

    I dont understand why it is showing. I checked complete spelling 

    It is not allowing me to make this new selectedcountry column.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi schapholkar ,

       

      In Power BI Desktop model view, you can interpret a relationship as being limited. A limited relationship is represented with parenthesis-like marks ( ) after the cardinality indicators.

       

      There are other restrictions related to limited relationships:

       

      The RELATED DAX function can not be used to retrieve the "one" side column values.

       

      Enforcing RLS has topology restrictions.

       

      For more on this, please see:

      Model relationships in Power BI Desktop - Power BI | Microsoft Learn

       

      Please make the appropriate changes according to the official documentation provided.

       

      Here is a view of my model:

       

      If you have any other questions please feel free to contact me.

       

      Best Regards,
      Yang
      Community Support Team

       

      If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
      If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!