cancel
Showing results for
Did you mean:
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.

Could someone help me?

1 ACCEPTED SOLUTION
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:

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:

3 REPLIES 3
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:

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:

Super User

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

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

Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
Check out my latest book!

Super User

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

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

Announcements

#### Launching new user group features

Learn how to create your own user groups today!