% Measure

[GhadaMehrez]

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??

% Actuals Booked =

DIVIDE(

[Actuals Booked],

CALCULATE(

[Actuals Booked],

ALL('Projects'[fls_StrategyThemeName])

)

)

[amitchandak]

@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.

[GhadaMehrez]

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 

[GhadaMehrez]

@amitchandak In the cards works good, but in the table looks like below: