cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Profpc
New Member

Comparison between table columns in Power BI

I'm Brazilian and Beginner in Power BI.

I need to make a comparison between two columns in a table, in case, discipline and shift. I need you to return to the number of lines that coincide with a discipline (mathematics) and a shift (daytime), for example.

I have searched Google and YouTube, but I have not found a solution.

Could someone help me?

1 ACCEPTED SOLUTION
ccakjcrx
Resolver I
Resolver I

@Profpc

 

Hey!

 

Based on your description, I created a table with values so I could try and find a solution for you. Here is my table:

 

tablescreenshot.jpg

 

I imported the table into power bi, and then used the following expression to count instances of where values under discipline was 'mathematics' and values under shift was 'daytime.'

 

Msr Countrows = 
CALCULATE(
    COUNTROWS(Sheet1),
    FILTER(Sheet1,Sheet1[Discipline] = "Mathematics"),
    FILTER(Sheet1,Sheet1[Shift] = "daytime")
)

I put a card on my power bi report and dropped the result of the measure into it:

 

msrsolution.jpg

View solution in original post

3 REPLIES 3
ccakjcrx
Resolver I
Resolver I

@Profpc

 

Hey!

 

Based on your description, I created a table with values so I could try and find a solution for you. Here is my table:

 

tablescreenshot.jpg

 

I imported the table into power bi, and then used the following expression to count instances of where values under discipline was 'mathematics' and values under shift was 'daytime.'

 

Msr Countrows = 
CALCULATE(
    COUNTROWS(Sheet1),
    FILTER(Sheet1,Sheet1[Discipline] = "Mathematics"),
    FILTER(Sheet1,Sheet1[Shift] = "daytime")
)

I put a card on my power bi report and dropped the result of the measure into it:

 

msrsolution.jpg

View solution in original post

One way would be to create a New Table with a formula like:

 

DisciplineShifts = SUMMARIZE(Disciplines,[Discipline],[Shift],"Count",COUNT(Disciplines[Discipline]))

@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

parry2k
Super User
Super User

@Profpc can you provide sample data and expected result? Your question is not very clear.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!