[Solved] Calculate Total male Total Female in powerbi report

To get the results you are looking for, follow these steps: Make a second table using the New Table button with the following code: GenderCounts = DISTINCT(TableName[Gender]) Make a relationship from the newly create table back to the original table Add a new column to the GenderCounts table with the following code: Count = COUNTROWS(RELATEDTABLE(TableName)) … Read more