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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
100 | |
98 | |
88 | |
70 |
User | Count |
---|---|
166 | |
131 | |
129 | |
102 | |
98 |