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
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!