Count Functions

[Anonymous]

Hello All,

Below attached my requirement in detail and this is regards to client count. 

Appreciate your help and let me know if you need further details

https://drive.google.com/file/d/1WqlixeRlvmKk50TEF5uQ5fZoS-Wx-o5J/view?usp=sharing

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may refer to the measure below.

Measure =
SUMX (
    VALUES ( Table1[Client Name] ),
    CALCULATE ( MAX ( 1, MAX ( Table1[Bundle client Counts] ) ) )
)