Exam PL-300 topic 4 question 27 discussion

Answer i s correct, tested.

Given answer tested and is correct

I think solution is not clearly fitting our goal. We are looking to identify which records have duplicated mail addresses, so we should use results from this calculated values identifying these fields where resuting value is grater than '1'. We can realize the DAX measure to populate the calculated column is labelled "Count email" so that's the objective of the formula. First we will encapsulate the entire calculation with CALCULATE to get rid of any context could affect that calculation, then we need to count which rows in the table (so COUNTROWS) have same email (this is the final condition comparing the "Email Address" field in the row) and this count should be applied to the entire table (then filter should be ALL customers)

It is not wrong on the calculated column but what can I do knowing which records have how many duplicates, to solve problem, shouldn't I try to find which record having same email address on each of the record?

Just want to say that the formula works without "all(Customer)," as well

Can someone please explain to me, how does counting the records help you identify which records have the same email address ?

for me it the picture is a bit strange - it looks like that one closing bracket is missing at the end of the picture (cut off the picture because currently the closing bracket it is not at the exact beginning of the last row). 1.) if the picture is correct with only one closing bracket then the last argument will be ALL 2.) if the picture is not correct and does not show the second closing bracket at the end then the last argument is FILTER Both is working but it depends on the number of closing brackts at the end.

Can somone explain why All? I dont get it..

Tested. Correct Calculate Countrows All

Answer is correct

should be countrows, filter, all

can anyone help to explain the answer in details?