Sometimes Incorrect Sum

[AC2982]

Hi -- I am building a PowerBI dashboard for an HIV program and I've run into an issue with a calculated measure (see formula below).  When I use this measure in a guage or multi-row card, the totals are correct.  But when I put this measure into a graph, the total are off.  I cannot figure out why.  The data are structured really simply in a single column for daily targets and their associated date.  Ive got the date linked up to another date table so I can include a date slicer.  But again... it is working on the guage and multi-row card.  What am I missing??

calculate(sum('HIV Tx Targets'[tx_new]), USERELATIONSHIP('HIV Tx Targets'[date], Dates[date]))

[Anonymous]

Hi @AC2982 ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Thank you.

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @AC2982 ,

I have constructed some data and everything looked fine on my side.

Could you please take a look at my pbix file and explain your queation detailly?

https://qiuyunus-my.sharepoint.com/:u:/g/personal/stephent01_qiuyunus_onmicrosoft_com/EYjr3ZmaaoFMhE...

Best Regards,
Eyelyn Qin

[PaulDBrown]

@AC2982 

If you are only using the HIV Tx Targets'[date], then you only need to link this field to your date table in a one-to-many relationship (make sure the date table covers the range of dates in the dataset and that dates are contiguous - if you are unsure how to create it, just use the table function CALENDARAUTO() ). You then don´t need the USRELATIONSHIP function: a simple SUM will work. 

[AC2982]

Thanks.  I tested this out with and without the userelationship function and the performance is still inconsistent.  The guage total is correct -- and filters correctly with the date slicer.  But the graphs have a different total.

[PaulDBrown]

@AC2982 

It would really help if you could provide a sample of your data and/or PBIX file to work on.

Please read this thread for more pointers:

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523