Matrix values not adapting to Slicer - Count Duplicates

[Larrauria]

Hi all, I have created a Matrix based on a calculated column: 

Duplicados = CALCULATE(COUNT([ID Candidato]),FILTER (Full, [ID Candidato] = EARLIER('Full'[ID Candidato]))). Total values in the Matrix are correct, but if I apply a filter/slicer then the values doesn't recalculate properly as the count of the values is different depending on the filter applied.

Is there a way of defining that colum to recalculate if a filter is applied?

Thanks 

[Larrauria]

Im using the following formula for the column "Duplicados":

Duplicados = CALCULATE(COUNT([ID Candidato]),FILTER (Full, [ID Candidato] = EARLIER('Full'[ID Candidato])))

If the formula is applied without filters the calculation is correct, but as soon as I apply a filter "Consultant" in this case the calculation fails


If the formula was working correctly last row should show 1 in field "Duplicados" but is doesnt because if the filter is removed that specific "ID Candidato" is repeated 2 more times by other Consultant.

I hope this explains the issue I have.

Thanks in advance

[AlB]

@Larrauria 

You seem to be mixing concepts.

I understand "Duplicados" is a calculated column. If so, its result will NOT change once it is calculated. Furthermore, the filter you are applying to the table are merely for visualizing, they do not change the contents of the table at all.

You'd have to do this through a table visual and a measure.

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[AlB]

Hi @Larrauria 

You'll have to explain better. Pelase provide some sample data and show the expected result based on that data.

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.