SUM and Count Mesure

[dofrancis3]

Dear collegues;

Hope my message find you well, 

Please could you help me with a DAX mesure 

As per the printscreen below :

1. I would like to Summarize "Female" column for all “Fail” and “Pass” Status column
2. I would like to Summarize "Female" column only for “Pass” Status column

Thank you for your support

Fd.

[Anonymous · Accepted solution]

Hi @dofrancis3 ,

The table data is shown below:

Please follow these steps:
1. Use the following DAX expression to create a measure named ‘FailOrPass ’

FailOrPass = SUMX(FILTER('Tabelle1',
 'Tabelle1'[Status] = "Fail" || 'Tabelle1'[Status] = "Pass"),
 'Tabelle1'[Female])

2. Use the following DAX expression to create a measure named ‘PassOnly ’

PassOnly = SUMX(FILTER('Tabelle1',
  'Tabelle1'[Status] = "Pass"),
  'Tabelle1'[Female])

3. Final output

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