Forum Discussion

New Member

3 years ago

Solved

ID Count with filter

I've got the date as shown below: Table ID 1 564080 1 648747 1 701842 1 701858 1 701859 1 701860 2 760287 2 760304 2 760371 2 760394 2 760397 2 ...

3 years ago

Try then:

Measure 1 = 
CALCULATE(
    DISTINCTCOUNT( Data[ID] ),
    REMOVEFILTERS( Data ),
    Data[Type] = 1
)

New Member

3 years ago

It doesn't work, both measures show the same value:

Frequent Visitor

3 years ago

Try then:

Measure 1 = 
CALCULATE(
    DISTINCTCOUNT( Data[ID] ),
    REMOVEFILTERS( Data ),
    Data[Type] = 1
)