cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
H_Jones Regular Visitor
Regular Visitor

Relationship removing data from report

Hey, I have created a relationship between a results table and a targets table but if there isnt results for all of the channels I have targets for, the target shown is only the total target for the channels with results, for example:

 

If I have results table which ends up looking like:

 

ChannelTrasactions
Email1000
Mail1000
SMS1000

 

And a targets table which is:

ChannelTargets
Email1100
Mail1000
SMS1100
Phone500

 

And they have a relationship on Channel (bare in mind the results table will actually be per transaction), then when I make a Guage for results and targets the target shown will only be 3200 i.e. doesn't include Phone as there want any results, can anyone find a way around this as its not showing true values.

 

Thanks,

Harriet.

1 ACCEPTED SOLUTION

Accepted Solutions
H_Jones Regular Visitor
Regular Visitor

Re: Relationship removing data from report

Sorry after some digging around I realised there was an error with one of the relationships.

 

Thanks!

 

H

View solution in original post

6 REPLIES 6
mehaboob557 Member
Member

Re: Relationship removing data from report

Hi @H_Jones,

 

Share pbix file

H_Jones Regular Visitor
Regular Visitor

Re: Relationship removing data from report

Hey @mehaboob557 I cant quickly share it as I would need to make a completely new fake datafile instead of using the organisational data, Is there any ideas just considering the what i have explained?

mehaboob557 Member
Member

Re: Relationship removing data from report

Hi @H_Jones,

 

Please let me know is my understanding is right or not

 

you have results and target tables and i hope channels is the primary key.

 

you are having one-one relationship?

 

and what filters you are using?

 

 

H_Jones Regular Visitor
Regular Visitor

Re: Relationship removing data from report

So it is a one - many as the results table is a line per transaction and Channel is the Primary Key/used to create the relationship.

 

No filter used for the visual.

mehaboob557 Member
Member

Re: Relationship removing data from report

Hi,

 

Please check sample file here

H_Jones Regular Visitor
Regular Visitor

Re: Relationship removing data from report

Sorry after some digging around I realised there was an error with one of the relationships.

 

Thanks!

 

H

View solution in original post

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors