Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
I want the mix of the 2 measures i created haha (test1, test2)
Thanks for your help in advance.
Solved! Go to 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 !
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 !
Hey @MrBrownn ,
what do you mean with "mix of the 2 measures"?
I also can't download the file:
Best regards
Denis
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" 🙂
Your file is still not downloadable...
this time it's the good one ! sorry about that
User | Count |
---|---|
112 | |
94 | |
87 | |
75 | |
65 |
User | Count |
---|---|
138 | |
112 | |
109 | |
98 | |
93 |