any reason why dataset

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Power BI training and help » Any reason why a dataset filtered the same way would appear diff

Any reason why a dataset filtered the same way would appear diff

resolvedResolved · Medium Priority · Version 365

Any reason why a dataset filtered the same way would appear diff

Hi there,

I have a report that I am using to track internal Activity on specific metrics. In this report, I have a dataset pulled which logs specific types of activities in our CRM automatically with a date, the user that made the activity, and some additional context around the "status" of the activity. For some reason, when I apply a filter for a specific week (using the datetable that Jens kindly shared after our training), as well as filtering for a specific user, it returns 1 row of data that matches the filters when viewing in report view, but when viewing the same dataset in table view it returns 7 rows of data.

Appreciate any help that can be offered here!
Thanks

RE: Any reason why a dataset filtered the same way would appear

Hi Angus,

Thank you for the forum question.

Do you have a model where you have a relationship going from the date table straight to the table which show 1 row or 7 rows?


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: Any reason why a dataset filtered the same way would appear

Here is the measure which is showing the incorrect data in case that is helpful!

Submitted Count =
COUNTROWS(
FILTER(
'Shortlist Updates',
CONTAINSSTRING('Shortlist Updates'[Shortlist Status], "submit")
)
)

RE: Any reason why a dataset filtered the same way would appear

Hi Angus,

Sorry I have been very busy.

I have time to look at it tomorrow.

Can I ask you to send me a screenshot of you data model thanks

Send it to info@stl-training.co.uk and please write in the subject that is to Jens.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: Any reason why a dataset filtered the same way would appear

Hi Jens - I managed to figure it out! The visual I had created was built across multiple tables so I had a "User" table linking everything together, but the table causing the issue had an inactive relationship, which meant that the visual was trying to assess matching rows given a different relationship that was still active.

RE: Any reason why a dataset filtered the same way would appear

Hi Jens - yes - happy to share the whole report with you although it is connected to our dataverse directly so the data will struggle to refresh for you I assume?

 

Training courses

 

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Power BI tip:

Page and Tab Shortcuts

Ctrl + Page Up/Page Down: Navigate between pages.
Ctrl + T: Create a new page.
Ctrl + Shift + F10: Toggle between fields pane and report canvas.

View all Power BI hints and tips


Server loaded in 0.06 secs.