The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Thanks Rongtie,
I Try to do a best explanation for my problem.
The problem is about CALCULATE.
First Syntax
With this syntax the row context can be apply normaly, a different value for every Agency.
If I use another formula, the value is good (3,70 TOTAL), but there is no several values with the agency context
Why ??
Thank a lot.
Hi @Loic_Pedro_Hans ,
Please have a try.
measure =
CALCULATE (
AVERAGE ( Delivery_Dte_Fioul_Particuliers[DELIVERY DATE] ),
FILTER (
ALL ( Delivery_Dte_Fioul_Particuliers ),
Delivery_Dte_Fioul_Particuliers[AGC_LIBC] IN { "PACA", "T-PSE Siège", "" }
)
)
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
80 | |
74 | |
41 | |
30 | |
28 |
User | Count |
---|---|
108 | |
96 | |
53 | |
48 | |
47 |