Ambiguous results when checking RI violations in Dax Studio

Power BI
1

Hello!

When I run Dax Studio I get a handful of RI violation alerts which I’m trying to investigate.The vPaq analyzer overview displays the alerts as expected, but when I go to the Relationships tab all alerts are gone.

For this particular case I’m focusing on [Fact] Survey Data which has two keys participating in a 1*M relationship.

When I run the two EXCEPT() queries I get a blank result.
When I run the SUMX() query I get 1 count of blank rows as a result.
When I check with backend they can’t find any RI violations between the tables involved.

Am I conducting my test in a wrong way?
Why is Dax Studio telling my that there are RI violations on the Overview page but that everything is fine on the Relationships tab?

image
image1260×614 49.8 KB

1 Like
2

Hi @Kristoffer.Dahlquist ,

you can check and take take advantage of Data Mentor

Suggested link for additional information:

1 Like
3

Hello there,

I am a developer myself and I found it very much useful and informative to be honest. Also, I have gone through this post which definitely helped me out a lot as a new member I am looking forward for more such discussions.

But could you guys help me as where could I post or create my own discussions as I am a new member here.

Thankyou in advance for your help and assistance,

1 Like
4

@Elizashahh welcome to Forum.

You can search existing topics and add new posts or you can create new one

  • just pick category (from the bar on the left )
  • on the upper right corner you can find +New Topic button

If you need more help, just let us know.

Enjoy.

5

for Entprise Data mentor you can check at :

Maybe for start you can check AI Tools → Advisors

more about Data mentor you can find at Sam’s course :slight_smile:

Enjoy learning.