Forum Discussion

uie07923's avatar
uie07923
Frequent Visitor
4 years ago

% from month - Calculate

Hi guys,    Sorry for the simple question. I have a measure with the simple SUM for a column (Tempo Ocupado CAL = SUM('ZCO08-CAL'[Atvd.a ser conf.])   I want to find out the % that it represents...
Need Help
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

Hi uie07923 

 

You could try this measure:

Percentage = DIVIDE(SUM('ZCO08-CAL'[Atvd.a ser conf.]),CALCULATE(SUM('ZCO08-CAL'[Atvd.a ser conf.]),ALLSELECTED('ZCO08-CAL'[Prensa])))

 

Another option is that you can drag 'ZCO08-CAL'[Atvd.a ser conf.] column into the Matrix visual as Values field. Then right click on it and select Sum and Show value as > Percent of column total. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.