Distinct count for two columns

[naseem_1973]

Hi All,

I am a new user of Power BI. I have a table in which one primary column has a duplicate value. 

I have counted this column's distinct values. But how do I count other column values according to this column's unique values?

I have used below measuer but its not working.

CountOtherColumnByPrimary =

SUMX(

    VALUES(Demographic[MRN]),

    CALCULATE(

        COUNTROWS(Demographic),

        ALLEXCEPT(Demographic, Demographic[MRN])

MRN is primiray column.

[Ashish_Mathur]

Hi,

Drag Gender to the Table visual and write this measure

Measure = distinctcount(Demographic[MRN])

Hope this helps.

[v-yangliu-msft]

Hi  @naseem_1973 ,

Do you mean counting by [MRN] and [Gender] grouping or do you mean counting the same number in the whole [Gender] based on the [Gender] of each [MRN].

The former:

Create measure.

Measure1 =
COUNTX(
  FILTER(ALL(Demographic),'Demographic'[MRN]=MAX('Demographic'[MRN])&&'Demographic'[Gender]=MAX('Demographic'[Gender])),[Gender])

Result：

The latter：

Create measure.

Measure2 =
var _select=SELECTCOLUMNS(FILTER(ALL(Demographic),'Demographic'[MRN]=MAX('Demographic'[MRN])),"column",[Gender])
return
COUNTX(
    FILTER(ALL(Demographic),
    'Demographic'[Gender] in _select&&'Demographic'[Gender]=MAX('Demographic'[Gender])),[Gender])

Result：

If that result does not meet your expectations, you can express the expected result in the form of a picture and we can help you better.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[naseem_1973]

Sir, 

I think you are not understand my query.

Mrn  Gender

123- Male

123  Male

211- Female

211-Femal

Keep in mind this scenario, I want to count 1 male and 1 female because both registrations same.