Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Measure with filters

Hi,   I want a measure that gives me the distinct count of Client ID that have 2 or more products. My table looks like this:   Client ID Total products Date 1 1 8/30/2019 2 1 8/30/...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    Try this measure

    =CALCULATE(DISTINCTCOUNT(Data[Client ID]),Data[Total Products]>=2)

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

Try this measure

=CALCULATE(DISTINCTCOUNT(Data[Client ID]),Data[Total Products]>=2)

Hope this helps.