How to combine already filtered rows based on one attribute?

[Anonymous]

I hope my Subject is good. Please somebody help me, because I can't find solution.

My table is in Power BI dashboard. I was creating this table based on some filters.

My filters:

Count of Idea is greater than or equal -> 2

Created 2019.01.01. - 2019.12.31

Employee: All

Departament: All

Status: Completed

In Power BI dashboard I see the table with results:

Departament	Count of Idea	Employee
IT	2	Peter
IT	5	John
Finance	3	Asli

It's ok, but I need to combine and to see this. I don't need to see Employees names, but I need to use some of the filters described above.

Departament	Count of Idea
IT	2
Finance	1

How can I count rows based on attribute Departament? I can't find solution how to count already counted values on table.

[tex628]

Do you have a table for your employees? 

[Anonymous]

I'm using Sharepoint list as a data source , where are:
• Employee (name, surname)
• Departament
• Idea (by Lean methodology)
• etc.

[tex628]

Measure =
Calculate(
Distinctcount('Table'[Employee]),
Summarize(
'Table',
'Table'[Employee],
'Table'[Department],
"Count of ID",
Countrows('Table')
)

Try this

[Anonymous]

Ok, but what is Count of ID in your Measure?

And how can I use filter Count of Idea is greater than or equal 2?

I see results, but it's not good results.

My data and filters:

I want to see this:

Padalinys (groups)	Count of ID
SD	4
FD	10

[tex628 · Accepted solution]

Count of ID is a column that is created only in that specific instance. It doesnt exist before the expression is evaluated. 

I forgot the Count of ID filter that you wanted to apply so i modified the measure a little bit. 

Measure = 
Calculate(
Distinctcount('Table'[Employee]),
Filter(
Summarize(
'Table',
'Table'[Employee],
'Table'[Department],
"Count of ID",
Countrows('Table')
),[Count of ID] > 1 )
)

Give it a try and llet me know if the results are correct. 

/J

[Anonymous]

Thank you. Everything is good