DAX - Formula to calculate the percentage of success to a test, among men and women, per year

[Arnaud]

Hi all,

I'm new to DAX. I face an issue about the calculation of a percentage of success to a test, among men and women, per year.

My main table contains one row per individual, identified by an ID.

In this table, I've got columns that give the ID, the gender ("Male" = 0, "Female" = 1), the year the individual performed the test, and whether the individual succeeded in the test ("No" = 0, "Yes" = 1).

I'd like to compute the percentage of success to the test, among men and women, per year.

What would be the formula that solves this issue ?

Thank you in advance for your help,

Best,

[v-chuncz-msft]

@Arnaud,

You may refer to the measure below.

Measure =
DIVIDE (
    CALCULATE ( DISTINCTCOUNT ( Table1[ID] ), Table1[test] = 1 ),
    DISTINCTCOUNT ( Table1[ID] )
)

[Arnaud]

Hi again,

Does your formula amount to that one ?

Measure =

DIVIDE(

COUNTX(FILTER('Table1';'Table1'[Test] = 1);'Table1'[ID]),

DISTINCTCOUNT('Table1'[ID])

)

Thank you for your feedback,

Regards,

Arnaud.

[Arnaud]

Hi Sam,

Thank you for your reply.

Shouldn't the gender also appear somewhere in the formula ?

Best,

Arnaud.