Forum Discussion
Anonymous
5 years agoNot applicable
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". ...
- 5 years ago
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.
simrantuli
Continued Contributor
5 years agoHi Anonymous,
Try using DISTINCTCOUNT function.