cancel
Showing results for
Did you mean:
Helper I

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

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!

1 ACCEPTED SOLUTION
Super User

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

If I helped you, click on the Thumbs Up to give Kudos.

Proud to be a Super User!

3 REPLIES 3
Super User

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

If I helped you, click on the Thumbs Up to give Kudos.

Proud to be a Super User!

Super User

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

If I helped you, click on the Thumbs Up to give Kudos.

Proud to be a Super User!

Helper I

Hi,@

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!

Announcements

#### The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

#### Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!