Forum Discussion
Different results between two visuals
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 !
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.
6 Replies
- amitchandak
Super User
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.
- simrantuli
Continued Contributor
Hi Anonymous,
Try using DISTINCTCOUNT function.
v-xiaotangCommunity Support
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.
