topic Gauge target value and using ISFILTERED with VALUES in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Gauge-target-value-and-using-ISFILTERED-with-VALUES/m-p/1118160#M16409 <P>Hi all</P><P>&nbsp;</P><P>I have a particular problem with multiple values selected.</P><P>&nbsp;</P><P><A href="https://youtu.be/rBTM0_RHiRk" target="_blank" rel="noopener">Here is a screen recording of my problem statement</A>&nbsp;</P><P>&nbsp;</P><P>measures in question:</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</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>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</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>Patna Depot</TD><TD>470353</TD><TD>1235.78</TD><TD>97.91%</TD></TR><TR><TD>NORTH</TD><TD>BIHAR</TD><TD>Purnia Depot</TD><TD>718320</TD><TD>964.32</TD><TD>97.03%</TD></TR><TR><TD>NORTH</TD><TD>EAST UP</TD><TD>Kanpur Co-pack Water</TD><TD>395458</TD><TD>625.1</TD><TD>97.00%</TD></TR><TR><TD>NORTH</TD><TD>EAST UP</TD><TD>Kanpur Depot</TD><TD>455390</TD><TD>685.1</TD><TD>96.02%</TD></TR><TR><TD>NORTH</TD><TD>JAMMU</TD><TD>BB Depot</TD><TD>70672</TD><TD>567.9</TD><TD>95.74%</TD></TR><TR><TD>NORTH</TD><TD>JAMMU</TD><TD>Jammu</TD><TD>37281</TD><TD>251.43</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>NORTH</TD><TD>NORTH EAST</TD><TD>Fatuha Depot</TD><TD>773091</TD><TD>1220.67</TD><TD>94.69%</TD></TR><TR><TD>NORTH</TD><TD>NORTH EAST</TD><TD>Gourpuri Depot</TD><TD>586602</TD><TD>1182.86</TD><TD>94.15%</TD></TR><TR><TD>NORTH</TD><TD>ODISHA</TD><TD>Khorda</TD><TD>1840150</TD><TD>2576.21</TD><TD>93.94%</TD></TR><TR><TD>NORTH</TD><TD>ODISHA</TD><TD>Khurda Depot</TD><TD>285980</TD><TD>383.15</TD><TD>92.92%</TD></TR><TR><TD>NORTH</TD><TD>ODISHA</TD><TD>Rourkela Depot</TD><TD>225762</TD><TD>374.36</TD><TD>92.75%</TD></TR><TR><TD>NORTH</TD><TD>SILIGURI</TD><TD>Asansol Depot</TD><TD>96855</TD><TD>156.75</TD><TD>92.25%</TD></TR><TR><TD>NORTH</TD><TD>SILIGURI</TD><TD>DC Fatapukur</TD><TD>578277</TD><TD>891.87</TD><TD>91.84%</TD></TR><TR><TD>NORTH</TD><TD>WEST UP</TD><TD>Dasna</TD><TD>3049662</TD><TD>5092.2</TD><TD>91.69%</TD></TR><TR><TD>NORTH</TD><TD>WEST UP</TD><TD>Jhilmil Depot</TD><TD>31416</TD><TD>292.74</TD><TD>91.67%</TD></TR><TR><TD>SOUTH</TD><TD>CHITTOOR</TD><TD>Srikalahasti</TD><TD>885760</TD><TD>1259.44</TD><TD>89.16%</TD></TR><TR><TD>SOUTH</TD><TD>HYDERABAD</TD><TD>Ameenpur</TD><TD>2513167</TD><TD>3455.15</TD><TD>88.60%</TD></TR><TR><TD>SOUTH</TD><TD>HYDERABAD</TD><TD>Bowrampet Depot - GT</TD><TD>104400</TD><TD>444</TD><TD>88.24%</TD></TR><TR><TD>SOUTH</TD><TD>HYDERABAD</TD><TD>Bowrampet Depot - NKA</TD><TD>51756</TD><TD>358.66</TD><TD>88.17%</TD></TR><TR><TD>SOUTH</TD><TD>HYDERABAD</TD><TD>Himjal Copack</TD><TD>496384</TD><TD>941.8</TD><TD>88.15%</TD></TR><TR><TD>SOUTH</TD><TD>HYDERABAD</TD><TD>Maula Ali Depot</TD><TD>303606</TD><TD>781.56</TD><TD>87.76%</TD></TR><TR><TD>SOUTH</TD><TD>KARNATAKA</TD><TD>Bangalore-Bidadi-DPG</TD><TD>2064650</TD><TD>3053.6</TD><TD>87.39%</TD></TR><TR><TD>SOUTH</TD><TD>KARNATAKA</TD><TD>Bharatiyam Copack</TD><TD>191820</TD><TD>248.4</TD><TD>86.15%</TD></TR><TR><TD>SOUTH</TD><TD>KARNATAKA</TD><TD>Bidadi Plant</TD><TD>86080</TD><TD>288</TD><TD>85.43%</TD></TR><TR><TD>SOUTH</TD><TD>KARNATAKA</TD><TD>Bidadi Plant 2</TD><TD>158015</TD><TD>141.96</TD><TD>85.38%</TD></TR><TR><TD>SOUTH</TD><TD>KARNATAKA</TD><TD>South KP Road Depot</TD><TD>5894</TD><TD>189.45</TD><TD>84.88%</TD></TR><TR><TD>SOUTH</TD><TD>KERALA</TD><TD>Cochin Depot</TD><TD>76560</TD><TD>487.2</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>Gangaikondan Copack</TD><TD>233520</TD><TD>483.72</TD><TD>84.14%</TD></TR><TR><TD>SOUTH</TD><TD>TAMIL NADU</TD><TD>Nemam</TD><TD>227672</TD><TD>336.16</TD><TD>83.12%</TD></TR><TR><TD>SOUTH</TD><TD>TAMIL NADU</TD><TD>Redhills Depot</TD><TD>700854</TD><TD>2100.12</TD><TD>82.85%</TD></TR><TR><TD>SOUTH</TD><TD>VIJAYAWADA</TD><TD>Atmakuru</TD><TD>2034774</TD><TD>2513.7</TD><TD>81.87%</TD></TR><TR><TD>SOUTH</TD><TD>VIZAG</TD><TD>Vizag Depot</TD><TD>477480</TD><TD>671.24</TD><TD>81.82%</TD></TR><TR><TD>WEST</TD><TD>GOA</TD><TD>Goa</TD><TD>165170</TD><TD>747</TD><TD>81.46%</TD></TR><TR><TD>WEST</TD><TD>MADHYA PRADESH</TD><TD>Bhopal</TD><TD>737334</TD><TD>1596.66</TD><TD>80.85%</TD></TR><TR><TD>WEST</TD><TD>NASIK</TD><TD>Aurangabad Depot</TD><TD>970212</TD><TD>1332.48</TD><TD>78.67%</TD></TR><TR><TD>WEST</TD><TD>PUNE</TD><TD>Kolhapur Depot</TD><TD>84564</TD><TD>155.52</TD><TD>76.17%</TD></TR><TR><TD>WEST</TD><TD>RAJASTHAN</TD><TD>Kaladhera</TD><TD>729495</TD><TD>1509.3</TD><TD>73.68%</TD></TR><TR><TD>WEST</TD><TD>RAJASTHAN</TD><TD>Udaipur Depot</TD><TD>202464</TD><TD>395.16</TD><TD>44.62%</TD></TR></TBODY></TABLE><P>any suggestion or comments are welcome</P><P>TIA</P><P>Anonymous</LI-USER>&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><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:21:36 GMT Anonymous 2020-05-25T16:21:36Z Gauge target value and using ISFILTERED with VALUES https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Gauge-target-value-and-using-ISFILTERED-with-VALUES/m-p/1118160#M16409 <P>Hi all</P><P>&nbsp;</P><P>I have a particular problem with multiple values selected.</P><P>&nbsp;</P><P><A href="https://youtu.be/rBTM0_RHiRk" target="_blank" rel="noopener">Here is a screen recording of my problem statement</A>&nbsp;</P><P>&nbsp;</P><P>measures in question:</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</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>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</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>Patna Depot</TD><TD>470353</TD><TD>1235.78</TD><TD>97.91%</TD></TR><TR><TD>NORTH</TD><TD>BIHAR</TD><TD>Purnia Depot</TD><TD>718320</TD><TD>964.32</TD><TD>97.03%</TD></TR><TR><TD>NORTH</TD><TD>EAST UP</TD><TD>Kanpur Co-pack Water</TD><TD>395458</TD><TD>625.1</TD><TD>97.00%</TD></TR><TR><TD>NORTH</TD><TD>EAST UP</TD><TD>Kanpur Depot</TD><TD>455390</TD><TD>685.1</TD><TD>96.02%</TD></TR><TR><TD>NORTH</TD><TD>JAMMU</TD><TD>BB Depot</TD><TD>70672</TD><TD>567.9</TD><TD>95.74%</TD></TR><TR><TD>NORTH</TD><TD>JAMMU</TD><TD>Jammu</TD><TD>37281</TD><TD>251.43</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>NORTH</TD><TD>NORTH EAST</TD><TD>Fatuha Depot</TD><TD>773091</TD><TD>1220.67</TD><TD>94.69%</TD></TR><TR><TD>NORTH</TD><TD>NORTH EAST</TD><TD>Gourpuri Depot</TD><TD>586602</TD><TD>1182.86</TD><TD>94.15%</TD></TR><TR><TD>NORTH</TD><TD>ODISHA</TD><TD>Khorda</TD><TD>1840150</TD><TD>2576.21</TD><TD>93.94%</TD></TR><TR><TD>NORTH</TD><TD>ODISHA</TD><TD>Khurda Depot</TD><TD>285980</TD><TD>383.15</TD><TD>92.92%</TD></TR><TR><TD>NORTH</TD><TD>ODISHA</TD><TD>Rourkela Depot</TD><TD>225762</TD><TD>374.36</TD><TD>92.75%</TD></TR><TR><TD>NORTH</TD><TD>SILIGURI</TD><TD>Asansol Depot</TD><TD>96855</TD><TD>156.75</TD><TD>92.25%</TD></TR><TR><TD>NORTH</TD><TD>SILIGURI</TD><TD>DC Fatapukur</TD><TD>578277</TD><TD>891.87</TD><TD>91.84%</TD></TR><TR><TD>NORTH</TD><TD>WEST UP</TD><TD>Dasna</TD><TD>3049662</TD><TD>5092.2</TD><TD>91.69%</TD></TR><TR><TD>NORTH</TD><TD>WEST UP</TD><TD>Jhilmil Depot</TD><TD>31416</TD><TD>292.74</TD><TD>91.67%</TD></TR><TR><TD>SOUTH</TD><TD>CHITTOOR</TD><TD>Srikalahasti</TD><TD>885760</TD><TD>1259.44</TD><TD>89.16%</TD></TR><TR><TD>SOUTH</TD><TD>HYDERABAD</TD><TD>Ameenpur</TD><TD>2513167</TD><TD>3455.15</TD><TD>88.60%</TD></TR><TR><TD>SOUTH</TD><TD>HYDERABAD</TD><TD>Bowrampet Depot - GT</TD><TD>104400</TD><TD>444</TD><TD>88.24%</TD></TR><TR><TD>SOUTH</TD><TD>HYDERABAD</TD><TD>Bowrampet Depot - NKA</TD><TD>51756</TD><TD>358.66</TD><TD>88.17%</TD></TR><TR><TD>SOUTH</TD><TD>HYDERABAD</TD><TD>Himjal Copack</TD><TD>496384</TD><TD>941.8</TD><TD>88.15%</TD></TR><TR><TD>SOUTH</TD><TD>HYDERABAD</TD><TD>Maula Ali Depot</TD><TD>303606</TD><TD>781.56</TD><TD>87.76%</TD></TR><TR><TD>SOUTH</TD><TD>KARNATAKA</TD><TD>Bangalore-Bidadi-DPG</TD><TD>2064650</TD><TD>3053.6</TD><TD>87.39%</TD></TR><TR><TD>SOUTH</TD><TD>KARNATAKA</TD><TD>Bharatiyam Copack</TD><TD>191820</TD><TD>248.4</TD><TD>86.15%</TD></TR><TR><TD>SOUTH</TD><TD>KARNATAKA</TD><TD>Bidadi Plant</TD><TD>86080</TD><TD>288</TD><TD>85.43%</TD></TR><TR><TD>SOUTH</TD><TD>KARNATAKA</TD><TD>Bidadi Plant 2</TD><TD>158015</TD><TD>141.96</TD><TD>85.38%</TD></TR><TR><TD>SOUTH</TD><TD>KARNATAKA</TD><TD>South KP Road Depot</TD><TD>5894</TD><TD>189.45</TD><TD>84.88%</TD></TR><TR><TD>SOUTH</TD><TD>KERALA</TD><TD>Cochin Depot</TD><TD>76560</TD><TD>487.2</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>Gangaikondan Copack</TD><TD>233520</TD><TD>483.72</TD><TD>84.14%</TD></TR><TR><TD>SOUTH</TD><TD>TAMIL NADU</TD><TD>Nemam</TD><TD>227672</TD><TD>336.16</TD><TD>83.12%</TD></TR><TR><TD>SOUTH</TD><TD>TAMIL NADU</TD><TD>Redhills Depot</TD><TD>700854</TD><TD>2100.12</TD><TD>82.85%</TD></TR><TR><TD>SOUTH</TD><TD>VIJAYAWADA</TD><TD>Atmakuru</TD><TD>2034774</TD><TD>2513.7</TD><TD>81.87%</TD></TR><TR><TD>SOUTH</TD><TD>VIZAG</TD><TD>Vizag Depot</TD><TD>477480</TD><TD>671.24</TD><TD>81.82%</TD></TR><TR><TD>WEST</TD><TD>GOA</TD><TD>Goa</TD><TD>165170</TD><TD>747</TD><TD>81.46%</TD></TR><TR><TD>WEST</TD><TD>MADHYA PRADESH</TD><TD>Bhopal</TD><TD>737334</TD><TD>1596.66</TD><TD>80.85%</TD></TR><TR><TD>WEST</TD><TD>NASIK</TD><TD>Aurangabad Depot</TD><TD>970212</TD><TD>1332.48</TD><TD>78.67%</TD></TR><TR><TD>WEST</TD><TD>PUNE</TD><TD>Kolhapur Depot</TD><TD>84564</TD><TD>155.52</TD><TD>76.17%</TD></TR><TR><TD>WEST</TD><TD>RAJASTHAN</TD><TD>Kaladhera</TD><TD>729495</TD><TD>1509.3</TD><TD>73.68%</TD></TR><TR><TD>WEST</TD><TD>RAJASTHAN</TD><TD>Udaipur Depot</TD><TD>202464</TD><TD>395.16</TD><TD>44.62%</TD></TR></TBODY></TABLE><P>any suggestion or comments are welcome</P><P>TIA</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><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:21:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Gauge-target-value-and-using-ISFILTERED-with-VALUES/m-p/1118160#M16409 Anonymous 2020-05-25T16:21:36Z