[Solved] DAX: please explain why this measure with a variable will not work [closed]

[ad_1] Your measure does not work because you are using a variable as the expression parameter of CALCULATE: variables are immutable; that means that once defined the behave like a constant, that means that their value cannot be changed. Variables are evaluated where they are defined and not where they are referenced; therefore their value … Read more

[Solved] Calculate Total male Total Female in powerbi report

[ad_1] 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 = … Read more