Suddenly blank values in slicers and visuals

[Anonymous]

Overnight I have gained blanks within all my slicers and visuals with no apparent reason why. I have followed this (https://www.youtube.com/watch?v=23qemkDqMVY) to the best of my ability and can see no problems with my mismatching data and this is occuring in all my slicers and visuals rather than just one. Are there other potential causes?

See below screenshot. I have 3020 blanks in the FEEDBACK ID column which is expected but there is no number listed against blanks for the JobRole ID column. So why is it showing if there are apparently none? 

[menglaro78]

Hi @Anonymous ,

can you please share your datamodel and the data view of your table which contains those fields?

Thanks

Marco

[amitchandak]

@Anonymous , are the Job ids missing in the dimension table, which are present in the fact?

[Anonymous]

I don't believe so. 

Fact table - JobRole ID column stats

Dimension - JobRole ID column stats

My data model is thus and i believe it is something to do with the relationships with the two fact tables as if i delete those the problem seems to correct itself 

[menglaro78]

Hi @Anonymous ,

I suggest to use Vertipaq Analyzer in DAX Studio in terms to understund if you have RI Violation and Missing Keys.
In my opinion this is the issue.

Marco

[Anonymous]

Hi Marco, 

I have DAX Studio but have never used it. I'll have to look into how to try your suggestion although if you know of a good resource for this please do not hesitate to share 🙂

[menglaro78]

HI,

go to Advanced Menu e click on view metrics.

If ypu want share with us, click on Export Metrics and upload vapx file in chat.

Marco

[Anonymous]

Hmm it appears you might be correct! Now then how to fix...

[menglaro78]

Hi @Anonymous ,

go to Relationship Tab and see relation with missing Keys

If you want see the occoriencies use this DAX code:

EVALUATE

    CALCULATETABLE(

        VALUES('Fact Sales'[Product ID]) ,

        ISBLANK('Dim Product'[Product ID])

        )

Marco

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[Anonymous]

trying out your code if I have interpreted it correctly i just get:

[menglaro78]

Hi,

you have to check the reports that have RI Violation.
From the code you posted you are analyzing a relationship between two DIMs that from your data model does not seem to exist.

Marco

[Anonymous]

Thanks for all your responses on this Marco, it is appreciated.

See violations below (is it normal to have that row including 'RowNumber-2662979B...'?. similar values appear in the other tables.)

Relationships & missing keys: 

Perhaps I have made a mistake i calling the employees table a dimension table. My model is such that I have a table of distinct employees linked to a fact table of survey responses but also linked via ID's to gender, ethnicity, team, job role etc etc dimension tables.

[menglaro78]

HI,

I don't understand why RI Violations are detected, but they are not seen in the Relationship tab.
If it's not a problem for you can you share the vpax file privately?

Marco

[Anonymous]

I have PM'd you, thanks again.