Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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". ...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    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.

v-xiaotang's avatar
v-xiaotang
Community Support
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.