Forum Discussion

GhadaMehrez's avatar
GhadaMehrez
Helper III
4 years ago

% Measure

 

 

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])
)
)

 

 

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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's avatar
      GhadaMehrez
      Helper III
      4 years ago

      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