cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bw70316 Member
Member

Model Relationships Returning Wrong Counts. Must have multiple Filters/Months comparison in on Viz

I am trying to compare multiple months data for count of placements. I was able to achieve this with composite models, but they won't publish to PBI. I have put my monthly files into groups so that they can be compared on one viz. I have created a total sheet comprised of all months to serve as a universal X-axis. 

 

To create my relationships, I am using a Many to One with a Single Cross Directional Filter by connecting through implemented index columns. When I create the viz, they seemingly look correct but are off by 2-8 numbers in the count?

 

UPDATE: I need to filter each placement by the county for each month (see bottom picture), which is why i split the tables separately and created groups for them in my edit queries. Any advice on how to create this model would be appreciated. I have included a photo below of the viz I developed using Composite Models, but again I am trying to create a dashboard for my boss, which is not currently permitted with PBI. 

 

 CM edit queries.png

Models.pngfacebook sdf.png

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Model Relationships Returning Wrong Counts. Must have multiple Filters/Months comparison in on V

Would need more information like sample data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

But, honestly, it seems a little weird to me to have your data separated out into separate tables for each month versus just having a single table with a month column.


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

3 REPLIES 3
Super User
Super User

Re: Model Relationships Returning Wrong Counts. Must have multiple Filters/Months comparison in on V

Would need more information like sample data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

But, honestly, it seems a little weird to me to have your data separated out into separate tables for each month versus just having a single table with a month column.


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

bw70316 Member
Member

Re: Model Relationships Returning Wrong Counts. Must have multiple Filters/Months comparison in on V

You were right. I just needed to utilize the months filter by county instead of each one individually. Thanks for pointing me in the right direction

v-cherch-msft Super Contributor
Super Contributor

Re: Model Relationships Returning Wrong Counts. Must have multiple Filters/Months comparison in on V

Hi @bw70316

 

It seems you've got the solution. If it is, please mark the helpful reply as solution. If not, please share some data sample and expected output. You can upload it to OneDrive or Dropbox and post the link here.

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 310 members 3,488 guests
Please welcome our newest community members: