Help with Calculated Column, Switch TRUE. PLEASE

Question

Hello,I have what i thought was a basic calculated column, but having issues that i can't explain or figure out. Please please help.&nbsp;Threshold = SWITCH(TRUE(),[Total Cash Claim] &gt; 3000 &amp;&amp; 'Cash Claims'[Employee Custom 11 - Name] = "Partner", "Partner", [Total Cash Claim] &gt; 1000 &amp;&amp; 'Cash Claims'[Employee Custom 11 - Name] &lt;&gt; "Partner", "Employee", "NO")&nbsp;Column description - If&nbsp;[Total Cash Claim] is &gt; 3000 &amp;&amp; [Employee Custom 11 - Name] =&nbsp;"Partner", then i want text to be "Partner"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;If&nbsp;[Total Cash Claim] is &gt; 1000 &amp;&amp; [Employee Custom 11 - Name] does not = "Partner", then i want text to&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;be "Employee", IF not, then "NO"&nbsp;WHen i place this column in a table, it is not displaying the correct result, additionally, it is changing the&nbsp;[Total Cash Claim] results.&nbsp;Please see Table A, i have the theshold column there but it changed the amount and also reporting "NO" rather than "Partner"&nbsp;I cannot seem to figure this out. Please help. Thank you&nbsp;&nbsp;&nbsp;

amitchandak · Answer

Coryanthony , The below will work only with [Total Cash Claim] is not a measure. 
&nbsp;
Threshold = SWITCH(TRUE(),[Total Cash Claim] &gt; 3000 &amp;&amp; 'Cash Claims'[Employee Custom 11 - Name] = "Partner", "Partner",[Total Cash Claim] &gt; 1000 &amp;&amp; 'Cash Claims'[Employee Custom 11 - Name] &lt;&gt; "Partner", "Employee", "NO")
&nbsp;
If [Total Cash Claim] is measured then you need a measure and dynamic Segmentation
&nbsp;measure
&nbsp;
Threshold = SWITCH(TRUE(),[Total Cash Claim] &gt; 3000 &amp;&amp; max('Cash Claims'[Employee Custom 11 - Name]) = "Partner", "Partner",[Total Cash Claim] &gt; 1000 &amp;&amp;max('Cash Claims'[Employee Custom 11 - Name])&nbsp; &lt;&gt; "Partner", "Employee", "NO")
&nbsp;
&nbsp;
&nbsp;
example
Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://youtu.be/EyL7KMw877Q

coryanthony · Answer

Hi&nbsp;amitchandak&nbsp;I did try eliminating the measure and while that did not change the amount, the logic was not accurate. I was not getting any "NO". If under the amounts i was still getting TRUE. Please see example below.&nbsp;I also want to count the amount of "Partner" and "Employee"; therefore, i was hoping to get this in a column.&nbsp;Threshold = SWITCH(TRUE(),SUM('Cash Claims'[Claimed Amount (rpt)]) &gt; 3000 &amp;&amp; 'Cash Claims'[Employee Custom 11 - Name] = "Partner", "Partner", SUM('Cash Claims'[Claimed Amount (rpt)]) &gt; 1000 &amp;&amp; 'Cash Claims'[Employee Custom 11 - Name] &lt;&gt; "Partner", "Employee", "NO")&nbsp;based on logic, highlighted should be "NO"&nbsp;&nbsp;&nbsp;I appreciate you so much. Thank you.

coryanthony · Answer

amitchandak&nbsp;I just watched you vidro and it was awesome. I should be able to make it with a measure.But if i wanted the calculated column, what would be the best approach?&nbsp;

Forum Discussion

Related content

TMDL - calculated column

Direct Lake Model - Calculated Column/Tables

Alternative to SWITCH ()?

Switch -Containsstring

Calculated column using switch