Forum Discussion

MonK's avatar
MonK
Regular Visitor
3 years ago
Solved

Filter with count function within a measure

Hi all,   I have a table with the following columns, among some other columns:   ID Type   Now I need a measure that will count the number of distinct IDs that occur more than 1x when filter...
  • Alf94's avatar
    Alf94
    3 years ago

    MonK,

     

    What (I think) you have to do is the following:

     

    Measure = 
    CALCULATE(
        DISTINCTCOUNT( 'Table'[ID] ),
        FILTER(
            ADDCOLUMNS(
                SUMMARIZE(
                'Table',
                'Table'[type],
                'Table'[ID]
                ),
                "count ID", CALCULATE( COUNT( 'Table'[ID] ) )
            ),
            [count ID] > 1
        ),
        Table[type] = "abc",
        Datediff(Table[Date1], Table[Date2]) <= 'What-If'[Value]
    )

     

    Let me know if this works.

MonK's avatar
MonK
Regular Visitor
3 years ago

thank you very much!