topic Re: Target values with ISFILTERED in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Target-values-with-ISFILTERED/m-p/1118215#M16415 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="32333" data-lia-user-login="nandukrishnavs" class="lia-mention lia-mention-user">nandukrishnavs</a>&nbsp;</P><P>&nbsp;</P><P>When multiple filters are selected, I want the gauge to show no target values.</P><P>&nbsp;</P><P>according to your suggestion of using when using (SUM) target values have stopped showing</P> Mon, 25 May 2020 17:08:19 GMT Anonymous 2020-05-25T17:08:19Z Target values with ISFILTERED https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Target-values-with-ISFILTERED/m-p/1118171#M16410 <P>Hi all</P><P>&nbsp;</P><P><A href="https://youtu.be/rBTM0_RHiRk" target="_self">Here is a screen recording to my problem statement</A>&nbsp;</P><P>&nbsp;</P><P>Sample Data:</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Plant Cluster</TD><TD>Plant Unit</TD><TD>Origin Name</TD><TD>Target Test.LBV_target</TD><TD>Target Test.LBW_Target</TD><TD>Loadability Weighted</TD></TR><TR><TD>NORTH</TD><TD>BIHAR</TD><TD>Purnia Depot</TD><TD>718320</TD><TD>964.32</TD><TD>97.91%</TD></TR><TR><TD>NORTH</TD><TD>NORTH EAST</TD><TD>Fatuha Depot</TD><TD>773091</TD><TD>1220.67</TD><TD>97.03%</TD></TR><TR><TD>NORTH</TD><TD>ODISHA</TD><TD>Rourkela Depot</TD><TD>225762</TD><TD>374.36</TD><TD>97.00%</TD></TR><TR><TD>NORTH</TD><TD>ODISHA</TD><TD>Khurda Depot</TD><TD>285980</TD><TD>383.15</TD><TD>96.02%</TD></TR><TR><TD>NORTH</TD><TD>BIHAR</TD><TD>Patna Depot</TD><TD>470353</TD><TD>1235.78</TD><TD>95.74%</TD></TR><TR><TD>NORTH</TD><TD>NORTH EAST</TD><TD>Gourpuri Depot</TD><TD>586602</TD><TD>1182.86</TD><TD>95.09%</TD></TR><TR><TD>NORTH</TD><TD>JHARKHAND</TD><TD>Ranchi New Depot</TD><TD>679728</TD><TD>1140.72</TD><TD>95.02%</TD></TR><TR><TD>WEST</TD><TD>PUNE</TD><TD>Kolhapur Depot</TD><TD>84564</TD><TD>155.52</TD><TD>94.69%</TD></TR><TR><TD>SOUTH</TD><TD>VIZAG</TD><TD>Vizag Depot</TD><TD>477480</TD><TD>671.24</TD><TD>94.15%</TD></TR><TR><TD>NORTH</TD><TD>SILIGURI</TD><TD>Asansol Depot</TD><TD>96855</TD><TD>156.75</TD><TD>93.94%</TD></TR><TR><TD>WEST</TD><TD>NASIK</TD><TD>Aurangabad Depot</TD><TD>970212</TD><TD>1332.48</TD><TD>92.92%</TD></TR><TR><TD>NORTH</TD><TD>ODISHA</TD><TD>Khorda</TD><TD>1840150</TD><TD>2576.21</TD><TD>92.75%</TD></TR><TR><TD>NORTH</TD><TD>SILIGURI</TD><TD>DC Fatapukur</TD><TD>578277</TD><TD>891.87</TD><TD>92.25%</TD></TR><TR><TD>SOUTH</TD><TD>VIJAYAWADA</TD><TD>Atmakuru</TD><TD>2034774</TD><TD>2513.7</TD><TD>91.84%</TD></TR><TR><TD>NORTH</TD><TD>EAST UP</TD><TD>Kanpur Co-pack Water</TD><TD>395458</TD><TD>625.1</TD><TD>91.69%</TD></TR><TR><TD>SOUTH</TD><TD>HYDERABAD</TD><TD>Ameenpur</TD><TD>2513167</TD><TD>3455.15</TD><TD>91.67%</TD></TR><TR><TD>WEST</TD><TD>GOA</TD><TD>Goa</TD><TD>165170</TD><TD>747</TD><TD>89.16%</TD></TR><TR><TD>NORTH</TD><TD>JAMMU</TD><TD>BB Depot</TD><TD>70672</TD><TD>567.9</TD><TD>88.60%</TD></TR><TR><TD>SOUTH</TD><TD>CHITTOOR</TD><TD>Srikalahasti</TD><TD>885760</TD><TD>1259.44</TD><TD>88.24%</TD></TR><TR><TD>WEST</TD><TD>RAJASTHAN</TD><TD>Kaladhera</TD><TD>729495</TD><TD>1509.3</TD><TD>88.17%</TD></TR><TR><TD>SOUTH</TD><TD>KARNATAKA</TD><TD>Bidadi Plant</TD><TD>86080</TD><TD>288</TD><TD>88.15%</TD></TR><TR><TD>WEST</TD><TD>RAJASTHAN</TD><TD>Udaipur Depot</TD><TD>202464</TD><TD>395.16</TD><TD>87.76%</TD></TR><TR><TD>NORTH</TD><TD>WEST UP</TD><TD>Dasna</TD><TD>3049662</TD><TD>5092.2</TD><TD>87.39%</TD></TR><TR><TD>WEST</TD><TD>MADHYA PRADESH</TD><TD>Bhopal</TD><TD>737334</TD><TD>1596.66</TD><TD>86.15%</TD></TR><TR><TD>SOUTH</TD><TD>TAMIL NADU</TD><TD>Gangaikondan Copack</TD><TD>233520</TD><TD>483.72</TD><TD>85.43%</TD></TR><TR><TD>SOUTH</TD><TD>KARNATAKA</TD><TD>Bangalore-Bidadi-DPG</TD><TD>2064650</TD><TD>3053.6</TD><TD>85.38%</TD></TR><TR><TD>NORTH</TD><TD>EAST UP</TD><TD>Kanpur Depot</TD><TD>455390</TD><TD>685.1</TD><TD>84.88%</TD></TR><TR><TD>NORTH</TD><TD>JAMMU</TD><TD>Jammu</TD><TD>37281</TD><TD>251.43</TD><TD>84.56%</TD></TR><TR><TD>SOUTH</TD><TD>TAMIL NADU</TD><TD>Coimbatore Depot</TD><TD>151041</TD><TD>519.39</TD><TD>84.37%</TD></TR><TR><TD>SOUTH</TD><TD>TAMIL NADU</TD><TD>Redhills Depot</TD><TD>700854</TD><TD>2100.12</TD><TD>84.14%</TD></TR><TR><TD>SOUTH</TD><TD>KERALA</TD><TD>Cochin Depot</TD><TD>76560</TD><TD>487.2</TD><TD>83.12%</TD></TR><TR><TD>SOUTH</TD><TD>TAMIL NADU</TD><TD>Nemam</TD><TD>227672</TD><TD>336.16</TD><TD>82.85%</TD></TR><TR><TD>NORTH</TD><TD>WEST UP</TD><TD>Jhilmil Depot</TD><TD>31416</TD><TD>292.74</TD><TD>81.87%</TD></TR><TR><TD>SOUTH</TD><TD>HYDERABAD</TD><TD>Himjal Copack</TD><TD>496384</TD><TD>941.8</TD><TD>81.82%</TD></TR><TR><TD>SOUTH</TD><TD>HYDERABAD</TD><TD>Maula Ali Depot</TD><TD>303606</TD><TD>781.56</TD><TD>81.46%</TD></TR><TR><TD>SOUTH</TD><TD>HYDERABAD</TD><TD>Bowrampet Depot - NKA</TD><TD>51756</TD><TD>358.66</TD><TD>80.85%</TD></TR><TR><TD>SOUTH</TD><TD>KARNATAKA</TD><TD>Bidadi Plant 2</TD><TD>158015</TD><TD>141.96</TD><TD>78.67%</TD></TR><TR><TD>SOUTH</TD><TD>KARNATAKA</TD><TD>Bharatiyam Copack</TD><TD>191820</TD><TD>248.4</TD><TD>76.17%</TD></TR><TR><TD>SOUTH</TD><TD>HYDERABAD</TD><TD>Bowrampet Depot - GT</TD><TD>104400</TD><TD>444</TD><TD>73.68%</TD></TR><TR><TD>SOUTH</TD><TD>KARNATAKA</TD><TD>South KP Road Depot</TD><TD>5894</TD><TD>189.45</TD><TD>44.62%</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Measures in question:</P><P>&nbsp;</P><LI-CODE lang="markup">Target Value LBW = IF( ISFILTERED('Prototype Modeling_Freight'[Origin Name]),CALCULATE(VALUES('Prototype Modeling_Freight'[Target Test.LBW_Target])), IF(ISFILTERED('Prototype Modeling_Freight'[Plant Unit]),CALCULATE(VALUES('Prototype Modeling_Freight'[TArget Test_PU.LBW_Target_PU])),BLANK())) </LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>Any commnet or suggestion is welcomed</P><P>TIA</P><P>&nbsp;</P><P>Anonymous</a>&nbsp;</P><P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="313" data-lia-user-login="Greg_Deckler" class="lia-mention lia-mention-user">Greg_Deckler</a>&nbsp;</P><P>&nbsp;</P><P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="32333" data-lia-user-login="nandukrishnavs" class="lia-mention lia-mention-user">nandukrishnavs</a>&nbsp;</P> Mon, 25 May 2020 16:32:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Target-values-with-ISFILTERED/m-p/1118171#M16410 Anonymous 2020-05-25T16:32:20Z Re: Target values with ISFILTERED https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Target-values-with-ISFILTERED/m-p/1118195#M16414 <P>Anonymous</a>&nbsp;</P><P>&nbsp;</P><P>If the user select multiple values, what is the expected output?</P><P>&nbsp;</P><P>For example, I have used <STRONG>SUM()</STRONG> instead of <STRONG>VALUES()</STRONG>.</P><P>&nbsp;</P><P>Try this</P><LI-CODE lang="csharp">Target Value LBW = IF ( ISFILTERED ( 'Prototype Modeling_Freight'[Origin Name] ), CALCULATE ( SUM ( 'Prototype Modeling_Freight'[Target Test.LBW_Target] ) ), IF ( ISFILTERED ( 'Prototype Modeling_Freight'[Plant Unit] ), CALCULATE ( SUM ( 'Prototype Modeling_Freight'[Target Test.LBW_Target] ) ), BLANK () ) )</LI-CODE><P>Change the logic based on your actual requirement.</P><P><BR /><BR /><STRONG>Did I answer your question? Mark my post as a solution!<BR />Appreciate with a kudos </STRONG><span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P> Mon, 25 May 2020 16:53:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Target-values-with-ISFILTERED/m-p/1118195#M16414 nandukrishnavs 2020-05-25T16:53:40Z Re: Target values with ISFILTERED https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Target-values-with-ISFILTERED/m-p/1118215#M16415 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="32333" data-lia-user-login="nandukrishnavs" class="lia-mention lia-mention-user">nandukrishnavs</a>&nbsp;</P><P>&nbsp;</P><P>When multiple filters are selected, I want the gauge to show no target values.</P><P>&nbsp;</P><P>according to your suggestion of using when using (SUM) target values have stopped showing</P> Mon, 25 May 2020 17:08:19 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Target-values-with-ISFILTERED/m-p/1118215#M16415 Anonymous 2020-05-25T17:08:19Z Re: Target values with ISFILTERED https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Target-values-with-ISFILTERED/m-p/1118225#M16416 <P>Anonymous</a>&nbsp; Okay, Then try to use HASONEVALUE()&nbsp; instead of ISFILTERED()&nbsp;</P><P><BR /><BR /><STRONG>Did I answer your question? Mark my post as a solution!<BR />Appreciate with a kudos </STRONG><span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Mon, 25 May 2020 17:12:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Target-values-with-ISFILTERED/m-p/1118225#M16416 nandukrishnavs 2020-05-25T17:12:54Z Re: Target values with ISFILTERED https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Target-values-with-ISFILTERED/m-p/1118230#M16417 <P><A href="https://nitieedu-my.sharepoint.com/:v:/g/personal/parth_sharma_2021_nitie_ac_in/EUrKpI29r49Nsn7pD5XK3FABjcQVgfbQnSyBFAFyb9558A?e=GNtom4" target="_self">What I mean by multiple selected values</A>&nbsp;</P> Mon, 25 May 2020 17:14:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Target-values-with-ISFILTERED/m-p/1118230#M16417 Anonymous 2020-05-25T17:14:42Z Re: Target values with ISFILTERED https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Target-values-with-ISFILTERED/m-p/1118239#M16418 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="32333" data-lia-user-login="nandukrishnavs" class="lia-mention lia-mention-user">nandukrishnavs</a>&nbsp;</P><P>Thank you very much. rescued me again <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Mon, 25 May 2020 17:21:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Target-values-with-ISFILTERED/m-p/1118239#M16418 Anonymous 2020-05-25T17:21:17Z