Forum Discussion
Solved
want sorting by Percentage
Data column”SEX“ is ”0“ and ”1“； Axis is ”REGION“， Value is ”SEX“ percentage； can't sorting by male（0） percentage， ps help，thanks
You can use the CALCULATE function to count filtered values.
Male %age = CALCULATE(Count([sex]),[sex] = "Male") / Count([sex])
