Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 |
---|---|
78 | |
75 | |
62 | |
60 | |
46 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |