Different results between two visuals

[Anonymous]

Hello,

In a table I display a number by personnel number. At the bottom of the table I get 93 which is the right number. This is not a measurement but just a field in a column set to "number of".

However when I display this same field in a visual like the one below. I don't get the same number. In my table I have duplicates for some personnel numbers. This makes me 111.

So a person can have several lines but I must retain only one time. Is there a solution apart from the deduplication in the form of a measure to obtain my result? 

I just want to find my 93 in the top left visual

Thank you !

[v-xiaotang · Accepted solution]

Hi @Anonymous 

The reason why you can’t get the same number 93 in card visual is: you filterd the column Nombre darret in table visual…but you didn’t filter the same column in card visual.

Table visual is able to categorize automatically according to the column Equipe & UO & Matricule, then you can filter column Nombre again based on the result. However, in card visual it doesn’t support this function. So, you need to create the measure bellow and put it in card visual:

distinct count total = SUMX(FILTER(SUMMARIZE('Polyabsent',Polyabsent[Matricule],"s",SUM(Polyabsent[Nombre d'arrêt])),[s]>=3),[s])

result:

Best Regards,

Community Support Team _ Tang

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

[Anonymous]

how to associate a sum with a distinct ?

I want to sum a field taking into account the distinction by matricule. I can't write this measure ?

[simrantuli]

Hi @Anonymous,

Try using DISTINCTCOUNT function.

[Anonymous]

how share a pbix file ?

[amitchandak]

@Anonymous , what you have used distinctcount or count or sum. In the 2 last cases, it should be the same in grand total in card and table, unless the table has a filter.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

https://drive.google.com/drive/folders/1No4O5VQ3Ipa0Q_hN86rRuqEfdVmgavj-?usp=sharing