How to count rows in a table using a filter condition as well as group by

[Anonymous]

Hello,

I would like to count the number of rows in a table using two conditions (using filter) as well as a group by.  I have never use group by with a filter.

Is it possible to do that and how.

Regards,

[v-easonf-msft · Accepted solution]

Hi ， @Anonymous 

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or your reply as Answered to close this thread?

Best Regards,
Community Support Team _ Eason

[Anonymous]

I don't know if I understood correctly the question but you can do something like:

COUNTROWS(
                     FILTER(
                                Table;
                                      Column1=condition1 &&
                                      Column2=condition2
                               (
)

And after that you put the measure in a matrix/chart with the column by which you want to "group by" in the axis and PowerBI will automatically perform the GROUPBY behaviour if the column is from the same table or there is an active relationship between the table from which you take the column and the table whose rows are counted in the measure

[parry2k]

@Anonymous hey yes it is possible, if you share sample data and expected output, it will help to provide the appropriate solution.  Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490