Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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.
@amitchandak I don't want the summary for all the "PS Groups", I only want the summary for the 3 selected PS Groups.
@Anonymous , Create a measure like this and use in visual with ops group
countrows(filter(Table, Table[Gender] ="Female")) +0
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |