Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap
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 |
---|---|
87 | |
74 | |
69 | |
58 | |
55 |
User | Count |
---|---|
40 | |
38 | |
34 | |
32 | |
30 |