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 "FE...
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.