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 custome...
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

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

AJ007's avatar
AJ007
Helper I
8 years ago

Thanks Lydia !