Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Percentage calculation

Hello everyone   I need to create a measure to calculate the percentage of the projet count 49/66 for the two matrix table below. The measure in both table is the same (Count ProJects), but the val...
Need Help
  • truptis's avatar
    truptis
    4 years ago

    Hi Anonymous ,

    Please try this measure:

    Result =

    DIVIDE(SUM(PROJECTCOUNT), CALCULATE (SUM(PROJECTCOUNT), ALLSELECTED()))

     

    Also, click on the measure, and select "show as values" and check if it is "percent of column total"

    Regards,

    Truptis

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks truptis  I figured out the measure.

 

Thanks

Fanis