Help with Measure to Subtotal by Date in an Unpivoted Table

[nicholastrausch]

Feeling like a noob this morning... for some reason I just can't seem to get this to come out right.  Hoping somebody can get me back on track.  

Straight forward table with a [Date], [Type] and [Count].  I need to sum the [Count] of all [Types] by [Date].  I've been messing with Calculate / SUMX variations.. but just can't get the right output.  Measure 1 created below in the xlsx needs to act as the denominator so that Measure 2 can be [Count] / [Measure 1].  Appreciate any help!

 

[Anonymous · Accepted solution]

@nicholastrausch 
Please create these two measures

TotalCountByDate = CALCULATE(SUM('Table'[Count]),ALLEXCEPT('Table','Table'[Date]))

Measure2 = 
VAR _count = SUM('Table'[Count])
RETURN DIVIDE(_count,[TotalCountByDate],0)

[nicholastrausch]

Thanks @Anonymous ! This did solve my problem.  I had simplified my table example down and had left out a few columns, but once I also added those the ALLEXCEPT function I am good.  Appreciate the help.