Calculate Total Value instead of showing the percentage in chart

[rajendraongole1]

Hi

I have created one matrix viz and using the two columns with one with category and % value. getting the percentage for each and every category in total field instead of showing overall percentage and i want to showcase the summation (Total). how to get it.

i have used all function and allselected to but the output i am not able to get as required. Please suggest.

In total i want to get 347.53 value 

Please suggest

[v-jingzhang]

Hi @rajendraongole1 

Currently the total is an average value of the above two categories. (336.87% + 10.66%) / 2 = 173.76%. If the %value is a column, in Values well, expand %value field and select Sum for aggregation. 

If %value is a measure, then can you share its DAX code and some sample data? Or at least you can try the measure @Samarth_18 has suggested. 

If you have found a solution, can you share it here with the community?

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

[mh2587]

use HASONVALUE & HASONFILTER Function in the return 

[Samarth_18]

Hi @rajendraongole1 ,

If you could share the code which you right with sample data in text format then it would be more helpful to answer but you can try to create a new measure like below and use it instead:-

Measure =
SUMX ( SUMMARIZE ( table, table[Process], "total", [%value] ), [total] )

Thanks,

Samarth