DAX Assistance Needed

Question

Hello - I need guidance on creating a formula.I need to show rows with same Line # and specific parts #s as configured or not configured.Example: If line 1.1 contains part #s 0678001000, 0678003000, 0678006000, 0678007000 and another Part with a "*" that would equal "configured". If line 1.1 contained one of the four part #s above, but no "*" part, then it would be "not configured"&nbsp;Configured Example: If Line 1.1 Contains Part # 0678003000 &amp; Part # with "*", the ConfiguedOrder Number&nbsp;&nbsp; &nbsp; &nbsp; LINE&nbsp;&nbsp; &nbsp;PART&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PART_DESCRIPTION21018225&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.1&nbsp;&nbsp; &nbsp;0678003*7461566&nbsp;&nbsp; &nbsp;PKG, SWITCHPOINT INFINITY 3 LITE21018225&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 1.1&nbsp;&nbsp; &nbsp;0678003000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; PKG, SWITCHPOINT INFINITY 3 LITE&nbsp;Thank you!

v-yulgu-msft · Accepted Answer

Hi&nbsp;jnail923,
&nbsp;
You could create a calculated column:

Check&nbsp;isConfigured&nbsp;=
VAR&nbsp;temp1&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;NOT&nbsp;(&nbsp;ISERROR&nbsp;(&nbsp;FIND&nbsp;(&nbsp;"0678001000",&nbsp;TestData[PART]&nbsp;)&nbsp;)&nbsp;)
VAR&nbsp;temp2&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;NOT&nbsp;(&nbsp;ISERROR&nbsp;(&nbsp;FIND&nbsp;(&nbsp;"0678003000",&nbsp;TestData[PART]&nbsp;)&nbsp;)&nbsp;)
VAR&nbsp;temp3&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;NOT&nbsp;(&nbsp;ISERROR&nbsp;(&nbsp;FIND&nbsp;(&nbsp;"0678006000",&nbsp;TestData[PART]&nbsp;)&nbsp;)&nbsp;)
VAR&nbsp;temp4&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;NOT&nbsp;(&nbsp;ISERROR&nbsp;(&nbsp;FIND&nbsp;(&nbsp;"0678007000",&nbsp;TestData[PART]&nbsp;)&nbsp;)&nbsp;)
VAR&nbsp;temp5&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;NOT&nbsp;(&nbsp;ISERROR&nbsp;(&nbsp;FIND&nbsp;(&nbsp;"*",&nbsp;TestData[PART]&nbsp;)&nbsp;)&nbsp;)
RETURN
&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(&nbsp;temp1&nbsp;||&nbsp;temp2
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;||&nbsp;temp3
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;||&nbsp;temp4&nbsp;)
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp;&nbsp;temp5&nbsp;=&nbsp;TRUE&nbsp;(),
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Configured",
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Not&nbsp;Configured"
&nbsp;&nbsp;&nbsp;&nbsp;)

&nbsp;
Then, when you add above fields into visual, you can filter out rows where "Check isConfigured" equals "Not Configured" via slicer or "visual level filters".
&nbsp;
Best regards,
Yuliana Gu

Forum Discussion

DAX Assistance Needed

2 Replies

Related content

DAX assistance needed

Need Assistance with Dax : Previous Year Sales Calculation

DAX SOLUTION NEEDED

Assistance Needed - DAX Measure

Dax Assistance Needed