Forum Discussion

AJ007's avatar
AJ007
Helper I
8 years ago
Solved

Filter Summarised Column by Measure

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.

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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