Repeat the result of measure filtring only by Year/Month

[MrBrownn]

Hello everyobody,

I have 2 tables, billing and details,
Billing corresponds to invoicing per month by type of treatment (Tax_Id)

In the detail table, I have the details for each company.
The aim is to have a result as follows

Slicer (year=2023),
Filter on all the page tax_Id = 6

Result =

Company	3	4	5
Etab1		160	250
Etab2	30
Etab3			250

Here is the PBI

=> Exemple <=

I want the mix of the 2 measures i created haha (test1, test2)

Thanks for your help in advance.

[MrBrownn · Accepted solution]

With a RELATED() Fonction, and using the same measure : 

Measure = VAR NbEtabs = CALCULATE(DISTINCTCOUNT(Etab), ALL(Etab)) VAR Montant = MAX('Operations DTCC'[RELATED(COLUMN)]) RETURN DIVIDE(Montant, NbEtabs)

My result is correct !

[selimovd]

Hey @MrBrownn ,

what do you mean with "mix of the 2 measures"?
I also can't download the file:

Best regards

Denis

[MrBrownn]

Hello @selimovd 

ho sorry, i updated my post for the pbix.

what I mean is : for the measure test1 : the display is correct but not the values.

on the other hand, the values of test2 is correct but not the display. 

so i want the display of "Test1" and the values of "test2" 🙂

[selimovd]

Your file is still not downloadable...

[MrBrownn]

this time it's the good one ! sorry about that