"Some" Measures not working

[BarryFletcher]

Morning all,

I am having an issue where some of my measures are working and some aren't even though there is only one word difference in the filter?

As seen in the image below, my measure / cards count the quantity based on the filter "Issue", "Checking" or "Backdrafting" work fine but the "Checking" filter for Meterage works even though the measure is the same with only the filter "For Issue", "For Checking" or "For Backdrafting" changes?

This is a copy of all the measures:

Progress Issue = CALCULATE(SUM('Pipe Export'[Cut Length]), 'In-Progress Isometrics Folder Scan'[Iso Status] = "For Issue")/1000 +0

Progress Checking = CALCULATE(SUM('Pipe Export'[Cut Length]), 'In-Progress Isometrics Folder Scan'[Iso Status] = "For Checking")/1000 +0

Progress Backdrafting = CALCULATE(SUM('Pipe Export'[Cut Length]), 'In-Progress Isometrics Folder Scan'[Iso Status] = "For Backdrafting")/1000 +0

The source table has the information being filtered on (as show by the fact that the  "For Checking" measure works.

Any ideas greatly appreciated....

[BarryFletcher · Accepted solution]

Hi all,

This has been resolved. The team producing the files in which I was calculating the SUM of have told me they created some dummy files and this was causing the measure to break. Apologies but maybe a tip for everyone to check their data source if they are not the creator of this source 😉

[BarryFletcher]

I've even changed the "For Checking" to just "Checking" and the same result - it counts the number of files but does not run the measure to Calculate the SUM

[BarryFletcher]

Hi there - thanks for the reply

The filter on the 3 left hand cards on the first image above is the same as the filter for the 3 cards on the right hand side (hope that makes sense) so if there was whitespace then all 6 would not work.

[FreemanZ]

hi @BarryFletcher ,

you may check if there is invisible space in your data, e.g. these two are different: "For Checking", "For Checking "