Hi i have a data column Gender
I need to count Male and Female and the average percentage will be 50%
Go to Solution.
Hi @blockobito ,
If you want to calculate the percentage of males and females in the total, you can try this code.
VAR _Total =
CALCULATE ( COUNT ( 'Table'[User] ), ALL ( 'Table' ) )
VAR _Each_Gender =
CALCULATE ( COUNT ( 'Table'[User] ) )
DIVIDE ( _Each_Gender, _Total )
Result is as below.
Best Regards,Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
Measure = CountRows(table)
Then place a visual with the gender and the Measure as the column. Can be added twice and use second as % of total.
If you need to split it up into separate records...
Measure Male =
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.