Distinct Count Total: Filtered Column to Match a Measure Returning Blank

Question

Good Morning,&nbsp;I have 2 measures&nbsp; &nbsp; &nbsp; Measure1 is to get a max weight within a 30 day retro window and then pull out those with "significant" wt loss (&gt; than 5%)&nbsp; &nbsp; &nbsp; Measure2 is to just get a distinct count of those patients that fell into the bucket of "significant wt loss.&nbsp;Measure2 is turning out to be much more difficult for me to figure out.&nbsp;&nbsp;Measure1:&nbsp;&nbsp;VAR Pt = SELECTEDVALUE(MSTR_Patient[PatientID]) VAR MaxDate = MAX(Dates[DayDate]) - 35 VAR MinDate = MAX(Dates[DayDate]) - 25 VAR PrevWt = CALCULATE(MAX(MeasurementValue[Lbs.]), DATESBETWEEN(Dates[DayDate], MaxDate, MinDate)) VAR SamePTChange = CALCULATE(PrevMeasurementValue[PatientID] = Pt)VAR CurrentWeight = SUMX(MeasurementValues,MeasurmentValues[Lbs.]) VAR FirstVisDate = MIN(Dates[DayDate]) VAR LastAdmRtnDate = CALCULATE(MAX(MeasurementValuesRTNDate]),Dates[DayDate] &lt;= FirstVisDate) VAR Day30MAX = SWITCH(TRUE(), CurrentWeight = BLANK(),BLANK(),&nbsp;&nbsp; LastAdmRtnDate &gt;MAX(Dates[DayDate]) - 30, BLANK(), SamePTChange) VAR WtLosslbs = Day30MAX - CurrentWeightVAR WtLossPercent = DIVIDE(WtLosslbs,Day30MAX, BLANK()) RETURN SWITCH(TRUE(),WtLossPercent &gt;= 0.05, SELECTEDVALUE(MeasurementValues[PatientID], BLANK() ))&nbsp;Measure2:&nbsp; &nbsp;CALCULATE&nbsp; &nbsp;(DISTINCTCOUNT(MeasurementValue[PatientID]), &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FILTER&nbsp; &nbsp;(MeasurementValues[PatientID] = Measure1,&nbsp; &nbsp; BLANK()&nbsp; &nbsp;))&nbsp;Measures 1 and 2 Pivot Table Result:&nbsp;Pt IDDate&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Measure1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Measure2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;1234&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/01/01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1234&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;No result/Blank2345&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/02/01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2345&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;No result/Blank&nbsp;From what I understand in Dax, Measure 2 should result since Measure1 Result does = the PtID&nbsp;I thought Measure1 would be the most difficult, but getting Measure2 is turning out to be much harder.&nbsp; I just need a distinct count of those that qualified in Measure1.&nbsp; &nbsp; If I adjust Measure2 without the filters and just a DISTINCTCOUNT (MeasurmentValue ([PatientID])&nbsp; &nbsp; &nbsp;I get a result, but it is of all the patients weighed.&nbsp; Not just those&nbsp; with the ID result from Measure1.&nbsp; &nbsp;&nbsp;Any Assistance would be greatly appreciated.&nbsp; &nbsp;Thank you!

v-alq-msft · Answer

Hi,&nbsp;Allisond&nbsp;
&nbsp;
You may try the following measure to see if it helps.
Measure2 =
CALCULATE (
    DISTINCTCOUNT ( MeasurementValue[PatientID] ),
    FILTER ( ALL ( MeasurementValues ), MeasurementValues[PatientID] = Measure1 )
)

&nbsp;
Best Regards
Allan
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Distinct Count Total: Filtered Column to Match a Measure Returning Blank

1 Reply

Related content

Distinct Count with filter

count distinct

Count Distinct only returns 1

Help with Filter + Distinct

Distinct Count, Filter