Solved: Count Functions

Anonymous · ‎05-06-2019

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 · ‎05-07-2019

@Anonymous ,

You may refer to the measure below.

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

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

View solution in original post

v-chuncz-msft · ‎05-07-2019

@Anonymous ,

You may refer to the measure below.

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

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