count of the common values in measure

[manideep547]

Hi All,

I have a scenario. I need to get repeated values in a measure based on some date constraint.

Example:

 Ids' may repeat in year.

I need a distinct count of Ids which are present in the first half as well as in the second half if I add date constraint as 6 months.

  In Slicer start date 1/06/2011 to 1/12/2011
Id      Date             Amount        Status(Measure)
1000      1/1/2011        25.00           Inactive
2000      2/2/2011        500.00          Inactive
1000      1/08/2011       89.00           active
2000      01/09/2011     45.00          Active
 Now I require the count of id. The output should be 2. 

[v-easonf-msft · Accepted solution]

Hi , @manideep547 

 Please try  the  measure as below :

count of id = 
COUNTROWS (
    FILTER (
        SUMMARIZE (
            'Table',
            'Table'[Id],
            "InDate", CALCULATE (
                SUM ( 'Table'[Amount ] ),
                'Table'[Date] IN FILTERS ( 'Date'[Date] )
            ),
            "OutDate", CALCULATE (
                SUM ( 'Table'[Amount ] ),
                NOT 'Table'[Date] IN FILTERS ( 'Date'[Date] )
            )
        ),
        [InDate] <> [OutDate]
    )
)

And it shows  as below :

Here  is  a sample :

https://wicren-my.sharepoint.com/:u:/g/personal/michael_wicren_onmicrosoft_com/EX76fEd_vw9GoBIJkSjHa... 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.