Forum Discussion

Milozebre's avatar
Milozebre
Helper V
8 years ago
Solved

same total for each row

Hello everyone,
I have a question.
I created a table with 2 Measures that work well.
I created a third one to calculate the percentage.
It works if I filter on a team but if I choose several, it gives me the same value.

Measure 1  :Nb Retour Enq EL EMEI Imhoweb BO = CALCULATE(DISTINCTCOUNT('Dossiers IWS'[IdAppel]);'Dossiers IWS'[LibelleAction] = "Avis Client"; 'Dossiers IWS'[YEAR_CLOTTECH] = YEAR(TODAY()))

Measure 2  : Nb Ticket EMEI Imhoweb = CALCULATE(DISTINCTCOUNT('Dossiers IWS'[IdAppel]); 'Dossiers IWS'[YEAR_CLOTTECH] = YEAR(TODAY()))

 

Measure 3  :Taux de Retour global = [Nb Retour Enq EL EMEI Imhoweb BO]/[Nb Ticket EMEI Imhoweb]
Do you have an idea ?

 

I make a filter on Libelle_Equipe_Clôture

 

Thank you in advance for your help

 

  • Anonymous

     

    Hello, 

     

    thanks for the feedback.
    I can't give an example of data. The tables are extremely heavy and result from SQL queries.
    I deleted my file and started again. The measures are working now. I changed nothing. I don't know what happened.


    thanks again

2 Replies

    • Milozebre's avatar
      Milozebre
      Helper V

      Anonymous

       

      Hello, 

       

      thanks for the feedback.
      I can't give an example of data. The tables are extremely heavy and result from SQL queries.
      I deleted my file and started again. The measures are working now. I changed nothing. I don't know what happened.


      thanks again