Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |