Pecentage based on Totals

[Invesco]

Hi Experts 

Hi Experts

I want to work out the percentage based on the total value for each category in the Custoemr Hourney column including the blank column. .How would i amend the following measure to give me this answer

Customer Journey Consent =

VAR _CJC = SUMX(VALUES(dev_con_hcp_universe_flipped[customer_journey]),[Total Consent])

Return

    _CJC

 The above measure gives me the breakdown per category...

[jgeddes]

Does 

Customer Journey Consent =

VAR _CJC = SUMX(VALUES(dev_con_hcp_universe_flipped[customer_journey]),[Total Consent])

VAR _TOTAL = SUMX(ALL(dev_con_hcp_universe_flipped),[Total Consent])

Return

 DIVIDE(_CJC, _TOTAL, 0)

Give you the result you are looking for?

[Invesco · Accepted solution]

Thanks i managed to work it out

Customer Journey Consent =

VAR _CJC = SUMX(VALUES(dev_con_hcp_universe_flipped[customer_journey]),[Total Consent])

VAR _TOTAL = SUMX(ALL(dev_con_hcp_universe_flipped[customer_journey]),[Total Consent])

Return

 DIVIDE(_CJC,_TOTAL,0)

[Invesco]

Hi jgeddes - no sorry. i was expecting each cate / 46192 = % value 

PREVIEW