How to Prevent Value From Changing When True Statement Is Met

Question

I have this measure and it works fine when the initial count of 5 is met (i.e. displays a 1).&nbsp; BUT, if the count goes over 5, then the value displayed is 0.&nbsp; I want it it to stay at 1 no matter what once the initial count is met.&nbsp; Is there a way to do that?&nbsp;AFC South = IF (CALCULATE(&nbsp;&nbsp;&nbsp;&nbsp;COUNT(Query2[TR#]),&nbsp;&nbsp;&nbsp;&nbsp;FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Query2,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Query2[BadgeName] = "AFC South" ||&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Query2[BadgeName] = "Houston Texans" ||&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Query2[BadgeName] = "Indianapolis Colts" ||&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Query2[BadgeName] = "Jacksonville Jaguars" ||&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Query2[BadgeName] = "Tennessee Titans"&nbsp;&nbsp;&nbsp;&nbsp;) ) = 5,1,0)

tommartens · Accepted Answer

Hey,
&nbsp;
I guess I do not fully understand the question, but maybe it's possible to "just" change the condition to
...
) &gt;= 5,1,0)
Regards,
Tom
&nbsp;

Forum Discussion

How to Prevent Value From Changing When True Statement Is Met

2 Replies

Related content

OR Statement ?

SQL Statement opcion error

Support for MERGE statement

Prevent data refresh error when column headers change or are removed

How to prevent unexpected query costs