Percentage calculation

[fanisgeorg]

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 values are different because different filters are applied to each matrix table.

Someone able to help?

Thanks

Fanis

[fanisgeorg]

Thanks @truptis  I figured out the measure.

Thanks

Fanis

[truptis · Accepted solution]

Hi @fanisgeorg ,

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