Dynamic Sum of Averages

[antoinersw]

Hello,

This is the data sample

Client	heures_quantity	duree_presta	€ HT Signes	Premier key_entry_client
A	16	284	4629.2	26/09/202271378
B	28	179	4522.73	03/01/202316723837
B	84	304	21361.07	10/03/202216723837

Here is a representation in the matrix :

Subtotal 1 should equals 16

Subtotal 2 should equal 56 (average of the 2 values of its category)

Grand total should equal 72 (56+16)

The date filtering is important. 

I tried to group by client but I lost the granularity of the date and therefore cannot filter anymore

Please advise me a solution in DAX.

Regards

[antoinersw]

thanks a lot it works like a charm

[CNENFRNL · Accepted solution]