Forum Discussion

Revathi_Kannan's avatar
Revathi_Kannan
Icon for Helper I rankHelper I
4 years ago
Solved

Dynamic RLS not working

Hi all,   I have 2 data tables, Scenario 101 and Filters wherein the common column for these 2 tables is Sap_company_code also i have my email id's list sheet 1 data table..   My requirement is, ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Revathi_Kannan ,

     

    Please firstly check if there is a blank cell in your tables, or create two measures by DISTINCTCOUNT and COUNTROWS to double verify whether the values are distinct.

     

    Generally, you need to fix the underlying data:

    * Remove blanks/nulls
    * Remove duplicates (of course)
    * Remove errors

    ......

    And delete the relationship, and then recreate the relationship to have a try again.

     

    Refer to:

    Power BI: The Cardinality you selected isn't valid for this relationship - deBUG.to

     

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Revathi_Kannan ,

 

Please firstly check if there is a blank cell in your tables, or create two measures by DISTINCTCOUNT and COUNTROWS to double verify whether the values are distinct.

 

Generally, you need to fix the underlying data:

* Remove blanks/nulls
* Remove duplicates (of course)
* Remove errors

......

And delete the relationship, and then recreate the relationship to have a try again.

 

Refer to:

Power BI: The Cardinality you selected isn't valid for this relationship - deBUG.to

 

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