Measure with userelationship wrong value in bar

[Anonymous]

Hi Guys,

I have a problem with my measure, only have 3 tables:

Calendar

Users

Shopping

When I do the operation to get the only number of users that I bought, it does not give me a problem, it shows me the result, but when I pass this value to a graph, other values ​​come to me, someone knows why. 

pbxi included

https://drive.google.com/open?id=1j155TBhCvAw6cEBE8TFGcsR5jQS5D0TB

Thx for your time and help.

Regrads.

[Johannesvd]

Hi @Anonymous,

im not exactly sure what you want to accomplish but if i interpret the data correctly try to change the measures to:

Total User USERELATIONSHIP = CALCULATE([Total User];USERELATIONSHIP(Users[Date];'Calendar'[Date]))

User with Shopping COMPLETE = CALCULATE(DISTINCTCOUNT(Shopping[id_user]);USERELATIONSHIP(Shopping[date shopping];'Calendar'[Date]))

and change the datakey relations to date

[Ashish_Mathur]

Hi,

What is the problem?  In the graph, you are getting month wise users.  What result are you expecting?

[Anonymous]

@Ashish_Mathur My problem is:

Any idea?? Thx

[Ashish_Mathur]

Hi,

I still do not undestand.  Share your file and show your expected result there.

[Anonymous]

Hi, thx for interesting im my problem. I want The same value shown on the card is the same as that shown on the graph. That is to say that sum bar to bar gives me the same value as in the card.