Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
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.
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
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |