Count Distinct Value irrespective of Month only Single Value should be shown

[Mavericks334]

Hi,

I have 5 columns Year, Qtr, ID, Volume Type and Date received in one table, Volume type in another table and a data table

I would like to get a unique count of values. The date received could be different, however if we concatenate the 1st four columns irrespective of which date it was received it should give me a unique value in the pivot, where the coulmn is months.

If the value occurs in July and then September It should could show the value under July or September not both.
eg:
[TABLE="width: 263"]
<tbody>[TR]
[TD]

<col style="mso-width-source:userset;mso-width-alt:6070;width:125pt" width="166"> <col style="mso-width-source:userset;mso-width-alt:3547;width:73pt" width="97"> <tbody>
[TD="class: xl65, width: 166"][/TD]
[TD="class: xl65, width: 166"][/TD]
[TD="class: xl65, width: 166"]Unqiue Value
[/TD]
[TD="class: xl65, width: 97"]Received Date[/TD]

[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]20153A123passwordreset
[/TD]
[TD="class: xl65"]31stjuly[/TD]

[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]20153A123passwordreset[/TD]
[TD="class: xl65"]1stjuly[/TD]

[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]20153A123passwordreset[/TD]
[TD="class: xl65"]30thAugust[/TD]

</tbody>

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Below is my measure

IFERROR(CALCULATE(DISTINCTCOUNT('CH Comments'[Unique Updates]),datesbetween(Dates[Dates],'Year_Period'[Selected_Month_Start_Date],'Year_Period'[Selected_Month_End_Date])),blank())
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Regards,
Renato.

 

[Matt Allington]

can you post a sample workbook. I am sure there is a better way, but it is hard to follow what you are saying

 

[Mavericks334]

Thanks Matt. The above measure worked fine for me.