Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter by measure

Hello, I am looking for a way to count the number of distinct lines following a measurement, An annual data set is retrieved in the same table allowing to make measurements vs previous years, Annu...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I find the solution

    Pris + Reste P A = CALCULATE(SUM(COMPTEUR_RS[Repos Compensateur Pris [jours]]])+SUM(COMPTEUR_RS[Repos Compensateur Reste à prendre [jours]]]);FILTER(COMPTEUR_RS;YEAR(COMPTEUR_RS[Période])=SELECTEDVALUE('DATE'[Année])))
     
     
    Total positifs = SUMX(VALUES(COMPTEUR_RS[Agent ID]);IF(CALCULATE(SUMX(COMPTEUR_RS;[Pris + Reste P A])-SUMX(COMPTEUR_RS;[Pris + Reste P A-1]))<0;0;CALCULATE(SUMX(COMPTEUR_RS;[Pris + Reste P A])-SUMX(COMPTEUR_RS;[Pris + Reste P A-1]))))
     
     
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

Not very clear. Are you want to add the measure to the distinct count calculation?

Such as:

calculate(distinctcount(value),filter(table,condition= measure))

If I misunderstand your meaning, please show some sample data and expected result.

 

Best Regards,

Jay