Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear collegues;
Hope my message find you well,
Please could you help me with a DAX mesure
As per the printscreen below :
Thank you for your support
Fd.
Solved! Go to 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.
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.