Count not appearing correct in a table

Amitkr174 — Fri, 20 Sep 2019 15:26:59 GMT

Hi,

Need help as the Count is not appearing correctly in a table. I have already applied some filters. Below are the measures used:-

1) # of Days =

DATEDIFF(LASTNONBLANK(Registration[Scheduled Class Start Date],1),LASTNONBLANK(Registration[Scheduled Class End Date],1),DAY)+1

2) Measure 6 = COUNTX(Registration, [# of Days])

When I put the registration number in the table the count appears 330 and if I remove the registration number it appears 1643.

I want to show the numbers without the registration table and ideal result would be 330.

Attached are the screenshots.

Re: Count not appearing correct in a table

MattAllington — Fri, 20 Sep 2019 22:17:16 GMT

You need to post a picture of the data model view, and also make it clear which tables each column comes from