Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Calculate totals for current month problem

Hello,

 

I am trying to calculate a number of totals, %, median time for the current month. I have 2 tables. One has the filter for this month:

the other table is the same but I put manually 2 filters for march 2022 (this month):

The 2 tables are not the same everywhere, some columns were not calculated properly:

Th 1st one has this month filter, the second one is the correct one (there's the march and 2022 filter on it)

 

For the number of demands (1st column there's a difference of 1, I don't know why); the formula of the column:

Total demandes = VAR __table = SUMMARIZE('Documents',[No-QR7],"__value",[Max nb demande])

            RETURN

IF(HASONEVALUE(Documents[No-QR7]),[Max nb demande],SUMX(__table,[__value]))

(Max nb demande= MAXX(Documents,DISTINCTCOUNT(Documents[No-QR7])))

I calculated with the max function because of duplicates and to calculate the sum of the column I had to summarize...

 

Problem for total documents : 

Total documents = COUNT(Documents[Id])

 

For Taux valides there's also a difference which is probably due to the number of demands that is not the same because Taux valides= Valides/total demandes

 

Can anyone help me?

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      amitchandak Sorry but I don't know how I could do that, everything comes from a confidential sharepoint (I can't modify to hide data) and I don't see how I can remove sensitive data from the pbix without the user being able to get it back

       

      I clicked to accept as solution without wanting to (sorry)