98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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
Resolved · Medium Priority · Version 365
Angus has attended:
Excel Advanced course
Power BI Modelling, Visualisation and Publishing course
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.
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Power BI tip:Page and Tab ShortcutsCtrl + Page Up/Page Down: Navigate between pages. |