Counting ELA and MATH

[syasmin25]

I have an issue and am having trouble wrapping my head around it. I am trying to count students absent in English and Math classes. The issue here is the database places students absent per period on a row to row basis. I have created a sample here. The original one is over a million rows.

I was wondering if there is any way I can create a column that counts number of students absent in MATH and ELA. I know I can do table. But I need to be looking more like the picture below (red font is where I want the calculation) and was wondering if someone could help.

[Anonymous]

Should your measure not be

DISTINCTCOUNT( Table[ID] )?

Best
D

[stevedep]

Hi,

The solution is available in the other equally named post.

Br

[HotChilli]

The simplest way might be to drag 'School ID' on to a table visualisation twice.  Make one 'Don't Summarize' . Make the other 'Count'

Then expand the filter pane and drag Subject on to 'Add data fields here' then tick ELA and MATH in basic filtering.