Calculate Sum of Distinct Count

[bjs0026]

Hello,

I am trying to create the sum of a distinct count using either a new measure or a new column. Right now my formula is counting distinct days of the year (excluding weekends) to count the number of week days for the month, taking into account starts/terms. The formula works on an individual level, but when aggregated to the entire population it only returns the distinct count, and not the total number of weekdays for all individuals.

In the photo above, i want the total to be 11 for January and 87 for February. This will give me 98 total working days for this group.

End goal is to use these work days to get 'Total Possible Hours' (Days*8 hrs)

[Greg_Deckler]

This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

[bjs0026]

Hey Greg thanks for the response. I tried using your post, but I am getting the same result. It is still showing just the distinct value count, rather than the sum of those distinct counts.

Here is my formula:

DayofYear = CALCULATE(DISTINCTCOUNT('Time Date'[Day of Year]),NOT(ISBLANK('Time Date'[Day of Year])),USERELATIONSHIP('Time Date'[pse__Timecard__c],Timecard[Id]))

Measure 8 = SUMX( SUMMARIZE('Time Date','Time Date'[MonthAbr],"SUM",[DayofYear]),[DayofYear])

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490