Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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,
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
Thanks Lydia !
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |