Return back total value for each line of Customer

[Anonymous]

Hi Experts

I want the total value against each line of customer...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...

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

The VALUES funtion in the formula returns the customer_journey in the current row according to the context. So you should replace it will ALL like this:

Customer Journey Consent =
VAR _CJC =
    SUMX ( ALL ( dev_con_hcp_universe_flipped[customer_journey] ), [Total Consent] )
RETURN
    _CJC

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.