Relationship removing data from report

[H_Jones]

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:

Channel	Trasactions
Email	1000
Mail	1000
SMS	1000

And a targets table which is:

Channel	Targets
Email	1100
Mail	1000
SMS	1100
Phone	500

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.

[mehaboob557]

Hi @H_Jones,

Share pbix file

[H_Jones]

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]

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]

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]

Hi,

Please check sample file here

[H_Jones · Accepted solution]

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

Thanks!

H