Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Please I have this measure to calculate % of {Actual Booked Cost} per each Strategy Theme from the {Total Actual Booked Cost}:
Here the measure works correctly in card visual but when I add it to the table it appear as 100% for all numbers and this not right any help what is the error??
@GhadaMehrez , Try like
% Actuals Booked =
DIVIDE(
[Actuals Booked],
CALCULATE(
[Actuals Booked],
ALL('Projects')
))
or
% Actuals Booked =
DIVIDE(
[Actuals Booked],
CALCULATE(
[Actuals Booked],
ALL()
))
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
I tried to send you a simplified file but when I do simple table it works good I don't know what is the problem
User | Count |
---|---|
93 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
112 | |
96 | |
94 | |
64 | |
58 |