Line graph with multiple measures having userelationship gives incorrect values

[Anonymous]

Hi Community,

I am stuck on a graph that doesn't show correct values for measures having userelatationship.  Following is a snapshot of the report:  On the graph there are incorrect values for the measure 'Services attended'. For example: Consider Nov2020, value of services attended =1 on the graph, but if I pull the values of the measure 'Services attended' for Nov2020 on a card, the value is correct (2).  Measure 'Cases_opened has correct values.

Expected values on the graph for 'Services attended' measure:

Also, if you can help me figure out the 'blank' in Month_year will be great.

Here is my pbi file: https://1drv.ms/u/s!Ag919_pO_UKrgQpvUDEhflhKY2xC?e=egMsPL

Many thanks in advance!

[Ashish_Mathur]

Hi,

It will help if you explain the business question, explain the data and show the expected result.  Show the expected result in a simple table.  Once we get the data in a table visual, we can always build any viz from it.

[Anonymous]

@Ashish_Mathur  I have updated my post. You can see the data in tabular fom in the atteched pbi file.

[Ashish_Mathur]

There is no table in the PowerBI Desktop file.

[Anonymous]

@Ashish_Mathur Sorry I am not sure what you mean by 'there is no table'. There is following table:

and if you select the graph visualization as a table, following is the output:

Expected result is:

Thanks

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.