visual meassure in donut chart and clustered bar chart

[kpipower]

Hi

I have problem with the visual data in graphic.

example:

I have two industry and I want to know how is the % of female and male. First industry have 38% female and 62% male and second industry have 100% male and 0 % female.

My meassure indicate SUMX, 38% female first industry + 0% second industry and divide between 2 (number of industry) the result is 19% this is true, but in Donut Chart and Clustered Bar Chart  just I can see 38% of first industry and not 19% the result of my meassure.

what is the prroblem? I don't understand.

Regards

[v-juanli-msft]

Hi @kpipower 

Is this problem sloved?

If not, please let me know.

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-juanli-msft · Accepted solution]

Hi @kpipower 

Assume [female] is a measure which you already have,

then create a measure to get the result of 19% as below,

"SUMX, 38% female first industry + 0% second industry and divide between 2 (number of industry) the result is 19% this is true,"

average-female = 
SUMX(ALL(Sheet9[industry]),[female])/CALCULATE(DISTINCTCOUNT(Sheet9[industry]),ALL(Sheet9))

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vanessafvg]

@kpipower 

are you able to provide the pbix file 

or please provide some data, with the actual measures as its hard to figure out what you asking