Count for Jan in Line Chart should be 13, why is it 139

[ahhollan]

The screenshot shows the count for January to be 139, however when I filter the data it should be 13. I can't find the issue with my measures or my filters. See screenshots.

[PhilipTreacy · Accepted solution]

Hi @ahhollan 

The figure of 139 is correct with the Measure you are using.  This measure gives a value of 139 because your axis and filter are using Fiscal Month from the Date table

Covid = CALCULATE ( COUNTROWS( '2700 WO Listing' ),'2700 WO Listing'[Covid vs Non-Covid (groups)] = "Covid" )

However what I think you are expecting is the value to be 13 when you filter by the Fiscal Month/Yr column in your 2700 WO Listing table.

That does indeed give you 13.

Regards

Phil

[pranit828]

HI @ahhollan 

It is due to the measure calculation as you are just doing a normal count from 2700 WO Listing table instead you need the count of IDs from mission critical table.

For each ID there can be multiple listings.

try

Covid = CALCULATE ( DISTINCTCOUNT( 'Mission Critical'[ID] ),'2700 WO Listing'[Covid vs Non-Covid (groups)] = "Covid" )

Check the difference in calculation

[PhilipTreacy]

Hi @ahhollan 

Please supply your PBIX file, can't really debug this without it.

Regards

Phil

[ahhollan]

https://www.dropbox.com/s/74kzzvtxyw8zzrj/2700%20stats.pbix?dl=0 

[ahhollan]

I can't seem to attach my pbix file. Please advise.

thanks.