Dax Calculation that Sum's Unique Values For that day by the Name

[Anonymous]

Hi,

I have a Calculated Column that needs to be summed up by each day. I only want the specific unique values to be counted so that it doesnt double/triple count. So for this data on 10/4/2021 I'd want only sum of 4.68 +2.1 = 6.78. There might be 3 unique values on that day too. I just want unique values to be summed from this column.

So I can have a calculation and throw it in a table. Can someone help me with this?

Thanks!

[PhilipTreacy]

hi @Anonymous 

I can't see what you are doing without seeing your data - can you supply your PBIX file?

You say 'but it is not summing up correctly' - how so?   

'The difference seems to be lower by 1 day' - I can't tell what you mean from your screenshot.  What's not summing up properly?

Regards

Phil

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Download sample PBIX file

Create a measure and use this code

SumValues = SUMX(VALUES('Table1'[Xim_Clock Hours]),[Xim_Clock Hours])

Change the table refewrence from 'Table1'  to whatever  the name of your table is.

Regards

Phil

[Anonymous]

Hi,@ PhilipTreacy

Thanks for getting back to me. This is pulling in the correct data,  but it is not summing up correctly?

Not sure, why unless I am missing something. The difference seems to be lower by 1 day consistently when I slice it differently...

Thanks again!