Calculate totals for current month problem

[Anonymous]

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?

[amitchandak]

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

[Anonymous]

@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)