cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Martyna_ Frequent Visitor
Frequent Visitor

How to combine already filtered rows based on one attribute?

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:

DepartamentCount of IdeaEmployee
IT2Peter
IT5John
Finance3Asli

 

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.

DepartamentCount of Idea
IT2
Finance1

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
tex628 New Contributor
New Contributor

Re: How to combine already filtered rows based on one attribute?

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

View solution in original post

6 REPLIES 6
tex628 New Contributor
New Contributor

Re: How to combine already filtered rows based on one attribute?

Do you have a table for your employees? 

Martyna_ Frequent Visitor
Frequent Visitor

Re: How to combine already filtered rows based on one attribute?

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

tex628 New Contributor
New Contributor

Re: How to combine already filtered rows based on one attribute?

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

Try this

 

Martyna_ Frequent Visitor
Frequent Visitor

Re: How to combine already filtered rows based on one attribute?

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:

data.png

I want to see this:

Padalinys (groups)Count of ID
SD4
FD10
tex628 New Contributor
New Contributor

Re: How to combine already filtered rows based on one attribute?

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

View solution in original post

Martyna_ Frequent Visitor
Frequent Visitor

Re: How to combine already filtered rows based on one attribute?

Thank you. Everything is good Smiley Happy

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 196 members 1,820 guests
Please welcome our newest community members: