Forum Discussion

Amitkr174's avatar
Amitkr174
Icon for Helper III rankHelper III
7 years ago

Count not appearing correct in a table

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.
 
 
 

1 Reply

  • MattAllington's avatar
    MattAllington
    Icon for Community Champion rankCommunity Champion
    7 years ago

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