topic Re: Counting ELA and MATH in DAX Commands and Tips

Counting ELA and MATH

syasmin25 — Fri, 29 May 2020 22:12:56 GMT

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.

Re: Counting ELA and MATH

HotChilli — Sat, 30 May 2020 14:09:09 GMT

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.

Re: Counting ELA and MATH

Anonymous — Sat, 30 May 2020 15:20:14 GMT

Should your measure not be

DISTINCTCOUNT( Table[ID] )?

Best
D

Re: Counting ELA and MATH

stevedep — Sat, 30 May 2020 15:46:55 GMT

Hi,

The solution is available in the other equally named post.