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.