The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Hi @Anonymous ,
can you please share your datamodel and the data view of your table which contains those fields?
Thanks
Marco
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
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
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 🙂
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
Hmm it appears you might be correct! Now then how to fix...
Hi @Anonymous ,
go to Relationship Tab and see relation with missing Keys
If you want see the occoriencies use this DAX code:
trying out your code if I have interpreted it correctly i just get:
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
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.
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
I have PM'd you, thanks again.
User | Count |
---|---|
80 | |
74 | |
41 | |
30 | |
28 |
User | Count |
---|---|
107 | |
96 | |
53 | |
47 | |
47 |