Filter Summarised Column by Measure

[AJ007]

I have an Excel sales table. It has customer gender as a separate column. Revenue is recorded in another separate column. I created two separate measures to calculate how many male and female customers there are. I now want to use these measures and see how much revenue was generated by a particular gender. It somehow doesn't work as Revenue always comes up as a summarized value of the whole column even though I map it with a particular gender measure.

[v-yuezhe-msft · Accepted solution]

@AJ007,

I create the following measures based on the sample data.

Revenue for male = CALCULATE(SUM(sales[Revenue]), FILTER(sales,sales[Gender]="Male"))
Revenue for female = CALCULATE(SUM(sales[Revenue]), FILTER(sales,sales[Gender]="Female"))


If the above DAX don't help, please share dummy data of your table for us to analyze.

Regards,

Lydia

[AJ007]

Thanks Lydia !