Forum Discussion
Summarizing Data
Hi Experts, I am very new to Power BI and I have been struggling for days trying to accomplish a simple task I can easily get done in Excel. My sample data below
I want to filter for only "FEMALES" in "PS Group" DU, EL, and FL to show as follows:
| Grade | Females |
| DU | 3 |
| EL | 2 |
| FL | 0 |
When this is done, I want this summary to work with my report Filters/Slicers - in the case where if I choose a particular year, the values should show me the number of females per grade for that particular year
Hi, Anonymous ;
Try to this measure.
Measure = CALCULATE(COUNT('Table'[PS group]),FILTER('Table',[Gender Ke]="Female"&&[PS group] in {"DU","FL","EL"}))The final show:
If the slicer selects a different year, the data will change accordingly.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Anonymous , Create a measure like this and use in visual with ops group
countrows(filter(Table, Table[Gender] ="Female")) +0
amitchandak I don't want the summary for all the "PS Groups", I only want the summary for the 3 selected PS Groups.
Hi, Anonymous ;
Try to this measure.
Measure = CALCULATE(COUNT('Table'[PS group]),FILTER('Table',[Gender Ke]="Female"&&[PS group] in {"DU","FL","EL"}))The final show:
If the slicer selects a different year, the data will change accordingly.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
