topic Re: Visualise differences with selectable reference in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Visualise-differences-with-selectable-reference/m-p/3684793#M143121 <P>ID_materialapplication quantity_Attribut_Value</P><TABLE><TBODY><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Test 1</TD><TD>13</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Test 2</TD><TD>200</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Test 3</TD><TD>56-75</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Test 4</TD><TD>17</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Test 5</TD><TD>56,4</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Test 6</TD><TD>86,6</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>X-axis</TD><TD>26,05</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Y-axis</TD><TD>-0,22</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Z-axis</TD><TD>-0,54</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>delta X to nearest standard</TD><TD>0,27</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>delta Y to nearest standard</TD><TD>-0,25</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>delta Z to nearest standard</TD><TD>0,01</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Test 13</TD><TD>0,1</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Test 16</TD><TD>7,1</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Test 17</TD><TD>cracks</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Test 18</TD><TD>cracks</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Test 19</TD><TD>G0</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Test 20</TD><TD>4,6</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Test 1</TD><TD>13</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Test 2</TD><TD>200</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Test 3</TD><TD>70-88</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Test 4</TD><TD>15,9</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Test 5</TD><TD>54,8</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Test 6</TD><TD>86,2</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>X-axis</TD><TD>26,17</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Y-axis</TD><TD>-0,33</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Z-axis</TD><TD>-0,6</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>delta X to nearest standard</TD><TD>0,39</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>delta Y to nearest standard</TD><TD>-0,36</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>delta Z to nearest standard</TD><TD>-0,05</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Test 13</TD><TD>0,13</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Test 16</TD><TD>7,3</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Test 17</TD><TD>small cracks</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Test 18</TD><TD>small cracks</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Test 19</TD><TD>G2</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Test 20</TD><TD>7,41</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Test 1</TD><TD>13</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Test 2</TD><TD>200</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Test 3</TD><TD>64-78</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Test 4</TD><TD>14,8</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Test 5</TD><TD>53</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Test 6</TD><TD>84,2</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>X-axis</TD><TD>26,24</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Y-axis</TD><TD>-0,42</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Z-axis</TD><TD>-0,59</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>delta X to nearest standard</TD><TD>0,46</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>delta Y to nearest standard</TD><TD>-0,45</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>delta Z to nearest standard</TD><TD>-0,04</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Test 13</TD><TD>0,08</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Test 16</TD><TD>7,6</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Test 17</TD><TD>cracks</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Test 18</TD><TD>cracks</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Test 19</TD><TD>G0</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Test 20</TD><TD>4,59</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Test 1</TD><TD>13</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Test 2</TD><TD>200</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Test 3</TD><TD>68-84</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Test 4</TD><TD>14,9</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Test 5</TD><TD>53</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Test 6</TD><TD>85</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>X-axis</TD><TD>25,98</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Y-axis</TD><TD>-0,3</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Z-axis</TD><TD>-0,45</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>delta X to nearest standard</TD><TD>0,32</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>delta Y to nearest standard</TD><TD>-0,32</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>delta Z to nearest standard</TD><TD>-0,02</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Test 13</TD><TD>0</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Test 16</TD><TD>7,3</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Test 17</TD><TD>cracks</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Test 18</TD><TD>cracks</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Test 19</TD><TD>G1</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Test 20</TD><TD>3,22</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Test 1</TD><TD>13</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Test 2</TD><TD>200</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Test 3</TD><TD>67-76</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Test 4</TD><TD>13,7</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Test 5</TD><TD>50,6</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Test 6</TD><TD>84,6</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>X-axis</TD><TD>26,65</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Y-axis</TD><TD>-0,97</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Z-axis</TD><TD>-0,35</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>delta X to nearest standard</TD><TD>0,99</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>delta Y to nearest standard</TD><TD>-0,99</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>delta Z to nearest standard</TD><TD>0,08</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Test 13</TD><TD>0,09</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Test 16</TD><TD>7,7</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Test 17</TD><TD>cracks</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Test 18</TD><TD>cracks</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Test 19</TD><TD>G0</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Test 20</TD><TD>4,47</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Test 1</TD><TD>13</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Test 2</TD><TD>200</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Test 3</TD><TD>79-88</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Test 4</TD><TD>10,4</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Test 5</TD><TD>45,7</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Test 6</TD><TD>83</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>X-axis</TD><TD>26,24</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Y-axis</TD><TD>-0,45</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Z-axis</TD><TD>-0,57</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>delta X to nearest standard</TD><TD>0,46</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>delta Y to nearest standard</TD><TD>-0,48</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>delta Z to nearest standard</TD><TD>-0,02</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Test 13</TD><TD>0,03</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Test 16</TD><TD>7,7</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Test 17</TD><TD>small cracks</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Test 18</TD><TD>small cracks</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Test 19</TD><TD>G1</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Test 20</TD><TD>5,43</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Test 1</TD><TD>13</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Test 2</TD><TD>200</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Test 3</TD><TD>67-80</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Test 4</TD><TD>9,3</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Test 5</TD><TD>42,5</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Test 6</TD><TD>82,4</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>X-axis</TD><TD>26,36</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Y-axis</TD><TD>-0,55</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Z-axis</TD><TD>-0,57</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>delta X to nearest standard</TD><TD>0,58</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>delta Y to nearest standard</TD><TD>-0,58</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>delta Z to nearest standard</TD><TD>-0,02</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Test 13</TD><TD>0,04</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Test 16</TD><TD>7,4</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Test 17</TD><TD>cracks</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Test 18</TD><TD>cracks</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Test 19</TD><TD>G0</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Test 20</TD><TD>4,44</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Test 1</TD><TD>13</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Test 2</TD><TD>200</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Test 3</TD><TD>78-85</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Test 4</TD><TD>9,5</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Test 5</TD><TD>43,2</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Test 6</TD><TD>81,3</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>X-axis</TD><TD>26,44</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Y-axis</TD><TD>-0,63</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Z-axis</TD><TD>-0,58</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>delta X to nearest standard</TD><TD>0,66</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>delta Y to nearest standard</TD><TD>-0,66</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>delta Z to nearest standard</TD><TD>-0,03</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Test 13</TD><TD>0,07</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Test 16</TD><TD>7,3</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Test 17</TD><TD>cracks</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Test 18</TD><TD>cracks</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Test 19</TD><TD>G0</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Test 20</TD><TD>5,16</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Test 1</TD><TD>13</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Test 2</TD><TD>200</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Test 3</TD><TD>56-76</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Test 4</TD><TD>9,9</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Test 5</TD><TD>43,7</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Test 6</TD><TD>82,2</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>X-axis</TD><TD>26,17</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Y-axis</TD><TD>-0,49</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Z-axis</TD><TD>-0,45</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>delta X to nearest standard</TD><TD>0,51</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>delta Y to nearest standard</TD><TD>-0,51</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>delta Z to nearest standard</TD><TD>-0,02</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Test 13</TD><TD>-0,05</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Test 16</TD><TD>7,9</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Test 17</TD><TD>cracks</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Test 18</TD><TD>cracks</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Test 19</TD><TD>G0</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Test 20</TD><TD>2,87</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Test 1</TD><TD>13</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Test 2</TD><TD>200</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Test 3</TD><TD>67-90</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Test 4</TD><TD>9,7</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Test 5</TD><TD>43,1</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Test 6</TD><TD>81,6</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>X-axis</TD><TD>28,22</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Y-axis</TD><TD>-2,51</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Z-axis</TD><TD>-0,29</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>delta X to nearest standard</TD><TD>2,56</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>delta Y to nearest standard</TD><TD>-2,53</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>delta Z to nearest standard</TD><TD>0,14</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Test 13</TD><TD>0,4</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Test 16</TD><TD>7,3</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Test 17</TD><TD>cracks</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Test 18</TD><TD>cracks</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Test 19</TD><TD>G1</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Test 20</TD><TD>3,36</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Test 1</TD><TD>13</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Test 2</TD><TD>200</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Test 3</TD><TD>63-79</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Test 4</TD><TD>17,5</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Test 5</TD><TD>57,5</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Test 6</TD><TD>86,4</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>X-axis</TD><TD>25,78</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Y-axis</TD><TD>0,03</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Z-axis</TD><TD>-0,55</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Test 16</TD><TD>7</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Test 17</TD><TD>cracks</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Test 18</TD><TD>cracks</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Test 19</TD><TD>G1</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Test 20</TD><TD>4,84</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Test 1</TD><TD>13</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Test 2</TD><TD>200</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Test 3</TD><TD>65-85</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Test 4</TD><TD>17,5</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Test 5</TD><TD>56,9</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Test 6</TD><TD>86,2</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>X-axis</TD><TD>25,66</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Y-axis</TD><TD>0,02</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Z-axis</TD><TD>-0,43</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>delta X to nearest standard</TD><TD>N/A</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Test 16</TD><TD>7,6</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Test 17</TD><TD>cracks</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Test 18</TD><TD>cracks</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Test 19</TD><TD>G0</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Test 20</TD><TD>5,55</TD></TR></TBODY></TABLE> Wed, 07 Feb 2024 06:33:57 GMT phill123 2024-02-07T06:33:57Z Visualise differences with selectable reference https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Visualise-differences-with-selectable-reference/m-p/3683215#M143055 <P>hello big power bi community,&nbsp;</P><P>&nbsp;</P><P>I am currently struggling with the following problem and hope that someone might have an idea how to solve it:<BR /><BR /></P><DIV class=""><SPAN class=""><STRONG><SPAN class=""><SPAN class="">Background:</SPAN></SPAN></STRONG><BR /><SPAN class=""><SPAN class="">Different materials with different concentrations were tested in a laboratory.</SPAN></SPAN> <SPAN class=""><SPAN class="">A lot of different tests were carried out, some of which provided numerical and some text-based results.</SPAN></SPAN> <SPAN class=""><SPAN class="">Each material was tested at two concentrations 1% and 3%.</SPAN></SPAN><BR /><U><SPAN class=""><SPAN class="">In order to define the general deviation of the process and the confidence range of the values, standards "1/2/3...." with 0% concentration was carryed out as well.</SPAN></SPAN></U><BR /><BR /><STRONG><SPAN class=""><SPAN class="">Report vision in total:</SPAN></SPAN></STRONG><BR /><SPAN class=""><SPAN class="">1 Page) Welcome page -&gt; Linked buttons to the individual pages with explanations of the pages and their use cases</SPAN></SPAN><BR /><SPAN class=""><SPAN class=""><BR />2 pages)</SPAN></SPAN> <SPAN class=""><SPAN class="">On the first report page the user should get an overview of the big data set.</SPAN></SPAN><BR /><SPAN class=""><SPAN class="">Contents:</SPAN></SPAN> <SPAN class=""><SPAN class="">Radar chart with all tests and filters by tests</SPAN></SPAN> <SPAN class=""><SPAN class="">+ Button to switch to Matrix/Table view</SPAN></SPAN><BR /><BR /><STRONG><SPAN class=""><SPAN class="">3 pages)</SPAN></SPAN> <SPAN class=""><SPAN class="">On the third report page, values should be compared to a self-defined referenz.</SPAN></SPAN> <SPAN class=""><SPAN class="">The user should use the slicer to select which experiment he would like to see the respective deviations for.</SPAN></SPAN> </STRONG><BR /><STRONG><SPAN class=""><SPAN class="">Contents:</SPAN></SPAN><BR /><SPAN class=""><SPAN class="">Visualizations for each test for each experiment/material show the respective absolute and % deviation from the previously defined referenz.<BR /></SPAN></SPAN></STRONG><SPAN>The deviation between the standards (that are actuall trials in the dataset) should be given as a confidence interval (can be solved in excel if necessary)</SPAN><BR /><BR /><SPAN class=""><SPAN class="">4 pages)</SPAN></SPAN> <SPAN class=""><SPAN class="">A material should first be selected on the 4th report page.</SPAN></SPAN> <SPAN class=""><SPAN class="">that filters the entire page.</SPAN></SPAN> <SPAN class=""><SPAN class="">The aim is to show how increasing the amount used influences the test result.</SPAN></SPAN><BR /><SPAN class=""><SPAN class="">Contents:</SPAN></SPAN> <SPAN class=""><SPAN class="">Visualizations for each test for just one material showing the two use concentrations 1% and 3%.</SPAN></SPAN><BR /><STRONG><SPAN class=""><SPAN class="">(optional)= also the deviation of the two concentrations to each other</SPAN></SPAN></STRONG><BR /><BR /><STRONG><SPAN class=""><SPAN class="">5 Page) -<U> (optional because it is very complicated)</U></SPAN></SPAN> </STRONG><BR /><STRONG><SPAN class=""><SPAN class="">The best match for a defined standard or set default values should be searched for on the 5th report page.</SPAN></SPAN> <SPAN class=""><SPAN class="">The goal is to find a material that has the same properties, regardless of concentration.</SPAN></SPAN></STRONG><BR /><BR /><SPAN class=""><SPAN class="">Best Match= lowest deviation in all tests</SPAN></SPAN><BR /><BR /><SPAN class=""><SPAN class="">To do this, you would have to aggregate (summarize) the results of all tests into one numerical value.</SPAN></SPAN><BR /><SPAN class=""><SPAN class="">Difficulty: Test results must be weighted differently and be adjustable with a slicer.</SPAN></SPAN></SPAN><DIV class="">&nbsp;</DIV><DIV class=""><STRONG><U>My Problem ist marked in bold:<BR /></U></STRONG></DIV><P><STRONG><U>* O<SPAN>n page 3 I can't calculate the deviation from a referenz selected dynamically with the Slicer<BR /></SPAN></U></STRONG></P><P><STRONG><U>* On page 4 I can't figure out how to calculate the deviation between the two concentrations for each material<BR />* I think page 5 is so complex that I see it as optional</U></STRONG></P><DIV class="">&nbsp;&nbsp;</DIV><DIV class=""><SPAN>Notes on the data set: [real data set includes approx. 100 materials and approx. 30 tests ]</SPAN></DIV></DIV><P><STRONG>Results are not only numerical but can also be text (here I am not yet sure how to solve this - perhaps numerical assignment?)</STRONG></P><P>&nbsp;</P><P><U>raw data:</U></P><TABLE><TBODY><TR><TD>ID</TD><TD>1</TD><TD>2</TD><TD>3</TD><TD>4</TD><TD>5</TD><TD>6</TD><TD>7</TD><TD>8</TD><TD>9</TD><TD>10</TD><TD>11</TD><TD>12</TD></TR><TR><TD>material</TD><TD>Standard 1</TD><TD>material 1</TD><TD>material 1</TD><TD>material 2</TD><TD>material 2</TD><TD>material 3</TD><TD>material 3</TD><TD>Standard 2</TD><TD>material 4</TD><TD>material 4</TD><TD>material 5</TD><TD>material 5</TD></TR><TR><TD>application quantity</TD><TD>0%</TD><TD>1%</TD><TD>3%</TD><TD>1%</TD><TD>3%</TD><TD>1%</TD><TD>3%</TD><TD>0%</TD><TD>1%</TD><TD>3%</TD><TD>1%</TD><TD>3%</TD></TR><TR><TD>Test 1</TD><TD>13</TD><TD>13</TD><TD>13</TD><TD>13</TD><TD>13</TD><TD>13</TD><TD>13</TD><TD>13</TD><TD>13</TD><TD>13</TD><TD>13</TD><TD>13</TD></TR><TR><TD>Test 2</TD><TD>200</TD><TD>200</TD><TD>200</TD><TD>200</TD><TD>200</TD><TD>200</TD><TD>200</TD><TD>200</TD><TD>200</TD><TD>200</TD><TD>200</TD><TD>200</TD></TR><TR><TD>Test 3</TD><TD>63-79</TD><TD>56-75</TD><TD>79-88</TD><TD>70-88</TD><TD>67-80</TD><TD>64-78</TD><TD>78-85</TD><TD>65-85</TD><TD>68-84</TD><TD>56-76</TD><TD>67-76</TD><TD>67-90</TD></TR><TR><TD>Test 4</TD><TD>17,5</TD><TD>17</TD><TD>10,4</TD><TD>15,9</TD><TD>9,3</TD><TD>14,8</TD><TD>9,5</TD><TD>17,5</TD><TD>14,9</TD><TD>9,9</TD><TD>13,7</TD><TD>9,7</TD></TR><TR><TD>Test 5</TD><TD>58</TD><TD>56</TD><TD>46</TD><TD>55</TD><TD>43</TD><TD>53</TD><TD>43</TD><TD>57</TD><TD>53</TD><TD>44</TD><TD>51</TD><TD>43</TD></TR><TR><TD>Test 6</TD><TD>86,4</TD><TD>86,6</TD><TD>83</TD><TD>86,2</TD><TD>82,4</TD><TD>84,2</TD><TD>81,3</TD><TD>86,2</TD><TD>85</TD><TD>82,2</TD><TD>84,6</TD><TD>81,6</TD></TR><TR><TD>X-axis</TD><TD>25,78</TD><TD>26,05</TD><TD>26,24</TD><TD>26,17</TD><TD>26,36</TD><TD>26,24</TD><TD>26,44</TD><TD>25,66</TD><TD>25,98</TD><TD>26,17</TD><TD>26,65</TD><TD>28,22</TD></TR><TR><TD>Y-axis</TD><TD>0,03</TD><TD>-0,22</TD><TD>-0,45</TD><TD>-0,33</TD><TD>-0,55</TD><TD>-0,42</TD><TD>-0,63</TD><TD>0,02</TD><TD>-0,3</TD><TD>-0,49</TD><TD>-0,97</TD><TD>-2,51</TD></TR><TR><TD>Z-axis</TD><TD>-0,55</TD><TD>-0,54</TD><TD>-0,57</TD><TD>-0,6</TD><TD>-0,57</TD><TD>-0,59</TD><TD>-0,58</TD><TD>-0,43</TD><TD>-0,45</TD><TD>-0,45</TD><TD>-0,35</TD><TD>-0,29</TD></TR><TR><TD>delta X to nearest standard</TD><TD>&nbsp;</TD><TD>0,27</TD><TD>0,46</TD><TD>0,39</TD><TD>0,58</TD><TD>0,46</TD><TD>0,66</TD><TD>&nbsp;</TD><TD>0,32</TD><TD>0,51</TD><TD>0,99</TD><TD>2,56</TD></TR><TR><TD>delta Y to nearest standard</TD><TD>&nbsp;</TD><TD>-0,25</TD><TD>-0,48</TD><TD>-0,36</TD><TD>-0,58</TD><TD>-0,45</TD><TD>-0,66</TD><TD>&nbsp;</TD><TD>-0,32</TD><TD>-0,51</TD><TD>-0,99</TD><TD>-2,53</TD></TR><TR><TD>delta Z to nearest standard</TD><TD>&nbsp;</TD><TD>0,01</TD><TD>-0,02</TD><TD>-0,05</TD><TD>-0,02</TD><TD>-0,04</TD><TD>-0,03</TD><TD>&nbsp;</TD><TD>-0,02</TD><TD>-0,02</TD><TD>0,08</TD><TD>0,14</TD></TR><TR><TD>Test 13</TD><TD>&nbsp;</TD><TD>0,1</TD><TD>0,03</TD><TD>0,13</TD><TD>0,04</TD><TD>0,08</TD><TD>0,07</TD><TD>&nbsp;</TD><TD>0</TD><TD>-0,05</TD><TD>0,09</TD><TD>0,4</TD></TR><TR><TD>Test 16</TD><TD>7</TD><TD>7,1</TD><TD>7,7</TD><TD>7,3</TD><TD>7,4</TD><TD>7,6</TD><TD>7,3</TD><TD>7,6</TD><TD>7,3</TD><TD>7,9</TD><TD>7,7</TD><TD>7,3</TD></TR><TR><TD>Test 17</TD><TD>cracks</TD><TD>cracks</TD><TD>small cracks</TD><TD>small cracks</TD><TD>cracks</TD><TD>cracks</TD><TD>cracks</TD><TD>cracks</TD><TD>cracks</TD><TD>cracks</TD><TD>cracks</TD><TD>cracks</TD></TR><TR><TD>Test 18</TD><TD>cracks</TD><TD>cracks</TD><TD>small cracks</TD><TD>small cracks</TD><TD>cracks</TD><TD>cracks</TD><TD>cracks</TD><TD>cracks</TD><TD>cracks</TD><TD>cracks</TD><TD>cracks</TD><TD>cracks</TD></TR><TR><TD>Test 19</TD><TD>G1</TD><TD>G0</TD><TD>G1</TD><TD>G2</TD><TD>G0</TD><TD>G0</TD><TD>G0</TD><TD>G0</TD><TD>G1</TD><TD>G0</TD><TD>G0</TD><TD>G1</TD></TR><TR><TD>Test 20</TD><TD>4,8</TD><TD>4,6</TD><TD>5,4</TD><TD>7,4</TD><TD>4,4</TD><TD>4,6</TD><TD>5,2</TD><TD>5,6</TD><TD>3,2</TD><TD>2,9</TD><TD>4,5</TD><TD>3,4</TD></TR></TBODY></TABLE><P><BR /><U><STRONG>Template/Test data transformed:</STRONG></U> <A href="https://drive.google.com/file/d/1h0AaFcy27DFRKkG1EIypkek5tecZns_X/view?usp=drivesdk" target="_self">Download</A><BR /><BR /></P><P>Many thanks in advance to everyone how give some feedback <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp;</P><P>BR</P><P>Phill</P> Mon, 12 Feb 2024 09:40:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Visualise-differences-with-selectable-reference/m-p/3683215#M143055 phill123 2024-02-12T09:40:05Z Re: Visualise differences with selectable reference https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Visualise-differences-with-selectable-reference/m-p/3684244#M143096 <P>Unpivot your data into a usable format</P> <P>&nbsp;</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="25%">ID</TD> <TD width="25%">Material</TD> <TD width="25%">Test</TD> <TD width="25%">Result</TD> </TR> <TR> <TD width="25%">&nbsp;</TD> <TD width="25%">&nbsp;</TD> <TD width="25%">&nbsp;</TD> <TD width="25%">&nbsp;</TD> </TR> </TBODY> </TABLE> Wed, 07 Feb 2024 00:31:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Visualise-differences-with-selectable-reference/m-p/3684244#M143096 lbendlin 2024-02-07T00:31:59Z Re: Visualise differences with selectable reference https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Visualise-differences-with-selectable-reference/m-p/3684793#M143121 <P>ID_materialapplication quantity_Attribut_Value</P><TABLE><TBODY><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Test 1</TD><TD>13</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Test 2</TD><TD>200</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Test 3</TD><TD>56-75</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Test 4</TD><TD>17</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Test 5</TD><TD>56,4</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Test 6</TD><TD>86,6</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>X-axis</TD><TD>26,05</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Y-axis</TD><TD>-0,22</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Z-axis</TD><TD>-0,54</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>delta X to nearest standard</TD><TD>0,27</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>delta Y to nearest standard</TD><TD>-0,25</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>delta Z to nearest standard</TD><TD>0,01</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Test 13</TD><TD>0,1</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Test 16</TD><TD>7,1</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Test 17</TD><TD>cracks</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Test 18</TD><TD>cracks</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Test 19</TD><TD>G0</TD></TR><TR><TD>2</TD><TD>material 1</TD><TD>1,00 %</TD><TD>Test 20</TD><TD>4,6</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Test 1</TD><TD>13</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Test 2</TD><TD>200</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Test 3</TD><TD>70-88</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Test 4</TD><TD>15,9</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Test 5</TD><TD>54,8</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Test 6</TD><TD>86,2</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>X-axis</TD><TD>26,17</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Y-axis</TD><TD>-0,33</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Z-axis</TD><TD>-0,6</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>delta X to nearest standard</TD><TD>0,39</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>delta Y to nearest standard</TD><TD>-0,36</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>delta Z to nearest standard</TD><TD>-0,05</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Test 13</TD><TD>0,13</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Test 16</TD><TD>7,3</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Test 17</TD><TD>small cracks</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Test 18</TD><TD>small cracks</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Test 19</TD><TD>G2</TD></TR><TR><TD>4</TD><TD>material 2</TD><TD>1,00 %</TD><TD>Test 20</TD><TD>7,41</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Test 1</TD><TD>13</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Test 2</TD><TD>200</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Test 3</TD><TD>64-78</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Test 4</TD><TD>14,8</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Test 5</TD><TD>53</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Test 6</TD><TD>84,2</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>X-axis</TD><TD>26,24</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Y-axis</TD><TD>-0,42</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Z-axis</TD><TD>-0,59</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>delta X to nearest standard</TD><TD>0,46</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>delta Y to nearest standard</TD><TD>-0,45</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>delta Z to nearest standard</TD><TD>-0,04</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Test 13</TD><TD>0,08</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Test 16</TD><TD>7,6</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Test 17</TD><TD>cracks</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Test 18</TD><TD>cracks</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Test 19</TD><TD>G0</TD></TR><TR><TD>6</TD><TD>material 3</TD><TD>1,00 %</TD><TD>Test 20</TD><TD>4,59</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Test 1</TD><TD>13</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Test 2</TD><TD>200</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Test 3</TD><TD>68-84</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Test 4</TD><TD>14,9</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Test 5</TD><TD>53</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Test 6</TD><TD>85</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>X-axis</TD><TD>25,98</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Y-axis</TD><TD>-0,3</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Z-axis</TD><TD>-0,45</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>delta X to nearest standard</TD><TD>0,32</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>delta Y to nearest standard</TD><TD>-0,32</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>delta Z to nearest standard</TD><TD>-0,02</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Test 13</TD><TD>0</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Test 16</TD><TD>7,3</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Test 17</TD><TD>cracks</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Test 18</TD><TD>cracks</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Test 19</TD><TD>G1</TD></TR><TR><TD>9</TD><TD>material 4</TD><TD>1,00 %</TD><TD>Test 20</TD><TD>3,22</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Test 1</TD><TD>13</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Test 2</TD><TD>200</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Test 3</TD><TD>67-76</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Test 4</TD><TD>13,7</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Test 5</TD><TD>50,6</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Test 6</TD><TD>84,6</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>X-axis</TD><TD>26,65</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Y-axis</TD><TD>-0,97</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Z-axis</TD><TD>-0,35</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>delta X to nearest standard</TD><TD>0,99</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>delta Y to nearest standard</TD><TD>-0,99</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>delta Z to nearest standard</TD><TD>0,08</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Test 13</TD><TD>0,09</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Test 16</TD><TD>7,7</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Test 17</TD><TD>cracks</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Test 18</TD><TD>cracks</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Test 19</TD><TD>G0</TD></TR><TR><TD>11</TD><TD>material 5</TD><TD>1,00 %</TD><TD>Test 20</TD><TD>4,47</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Test 1</TD><TD>13</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Test 2</TD><TD>200</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Test 3</TD><TD>79-88</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Test 4</TD><TD>10,4</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Test 5</TD><TD>45,7</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Test 6</TD><TD>83</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>X-axis</TD><TD>26,24</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Y-axis</TD><TD>-0,45</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Z-axis</TD><TD>-0,57</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>delta X to nearest standard</TD><TD>0,46</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>delta Y to nearest standard</TD><TD>-0,48</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>delta Z to nearest standard</TD><TD>-0,02</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Test 13</TD><TD>0,03</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Test 16</TD><TD>7,7</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Test 17</TD><TD>small cracks</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Test 18</TD><TD>small cracks</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Test 19</TD><TD>G1</TD></TR><TR><TD>3</TD><TD>material 1</TD><TD>3,00 %</TD><TD>Test 20</TD><TD>5,43</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Test 1</TD><TD>13</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Test 2</TD><TD>200</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Test 3</TD><TD>67-80</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Test 4</TD><TD>9,3</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Test 5</TD><TD>42,5</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Test 6</TD><TD>82,4</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>X-axis</TD><TD>26,36</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Y-axis</TD><TD>-0,55</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Z-axis</TD><TD>-0,57</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>delta X to nearest standard</TD><TD>0,58</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>delta Y to nearest standard</TD><TD>-0,58</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>delta Z to nearest standard</TD><TD>-0,02</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Test 13</TD><TD>0,04</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Test 16</TD><TD>7,4</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Test 17</TD><TD>cracks</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Test 18</TD><TD>cracks</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Test 19</TD><TD>G0</TD></TR><TR><TD>5</TD><TD>material 2</TD><TD>3,00 %</TD><TD>Test 20</TD><TD>4,44</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Test 1</TD><TD>13</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Test 2</TD><TD>200</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Test 3</TD><TD>78-85</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Test 4</TD><TD>9,5</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Test 5</TD><TD>43,2</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Test 6</TD><TD>81,3</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>X-axis</TD><TD>26,44</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Y-axis</TD><TD>-0,63</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Z-axis</TD><TD>-0,58</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>delta X to nearest standard</TD><TD>0,66</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>delta Y to nearest standard</TD><TD>-0,66</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>delta Z to nearest standard</TD><TD>-0,03</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Test 13</TD><TD>0,07</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Test 16</TD><TD>7,3</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Test 17</TD><TD>cracks</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Test 18</TD><TD>cracks</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Test 19</TD><TD>G0</TD></TR><TR><TD>7</TD><TD>material 3</TD><TD>3,00 %</TD><TD>Test 20</TD><TD>5,16</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Test 1</TD><TD>13</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Test 2</TD><TD>200</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Test 3</TD><TD>56-76</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Test 4</TD><TD>9,9</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Test 5</TD><TD>43,7</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Test 6</TD><TD>82,2</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>X-axis</TD><TD>26,17</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Y-axis</TD><TD>-0,49</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Z-axis</TD><TD>-0,45</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>delta X to nearest standard</TD><TD>0,51</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>delta Y to nearest standard</TD><TD>-0,51</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>delta Z to nearest standard</TD><TD>-0,02</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Test 13</TD><TD>-0,05</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Test 16</TD><TD>7,9</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Test 17</TD><TD>cracks</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Test 18</TD><TD>cracks</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Test 19</TD><TD>G0</TD></TR><TR><TD>10</TD><TD>material 4</TD><TD>3,00 %</TD><TD>Test 20</TD><TD>2,87</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Test 1</TD><TD>13</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Test 2</TD><TD>200</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Test 3</TD><TD>67-90</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Test 4</TD><TD>9,7</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Test 5</TD><TD>43,1</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Test 6</TD><TD>81,6</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>X-axis</TD><TD>28,22</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Y-axis</TD><TD>-2,51</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Z-axis</TD><TD>-0,29</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>delta X to nearest standard</TD><TD>2,56</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>delta Y to nearest standard</TD><TD>-2,53</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>delta Z to nearest standard</TD><TD>0,14</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Test 13</TD><TD>0,4</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Test 16</TD><TD>7,3</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Test 17</TD><TD>cracks</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Test 18</TD><TD>cracks</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Test 19</TD><TD>G1</TD></TR><TR><TD>12</TD><TD>material 5</TD><TD>3,00 %</TD><TD>Test 20</TD><TD>3,36</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Test 1</TD><TD>13</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Test 2</TD><TD>200</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Test 3</TD><TD>63-79</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Test 4</TD><TD>17,5</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Test 5</TD><TD>57,5</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Test 6</TD><TD>86,4</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>X-axis</TD><TD>25,78</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Y-axis</TD><TD>0,03</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Z-axis</TD><TD>-0,55</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Test 16</TD><TD>7</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Test 17</TD><TD>cracks</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Test 18</TD><TD>cracks</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Test 19</TD><TD>G1</TD></TR><TR><TD>1</TD><TD>Standard 1</TD><TD>0,00 %</TD><TD>Test 20</TD><TD>4,84</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Test 1</TD><TD>13</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Test 2</TD><TD>200</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Test 3</TD><TD>65-85</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Test 4</TD><TD>17,5</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Test 5</TD><TD>56,9</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Test 6</TD><TD>86,2</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>X-axis</TD><TD>25,66</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Y-axis</TD><TD>0,02</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Z-axis</TD><TD>-0,43</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>delta X to nearest standard</TD><TD>N/A</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Test 16</TD><TD>7,6</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Test 17</TD><TD>cracks</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Test 18</TD><TD>cracks</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Test 19</TD><TD>G0</TD></TR><TR><TD>8</TD><TD>Standard 2</TD><TD>0,00 %</TD><TD>Test 20</TD><TD>5,55</TD></TR></TBODY></TABLE> Wed, 07 Feb 2024 06:33:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Visualise-differences-with-selectable-reference/m-p/3684793#M143121 phill123 2024-02-07T06:33:57Z Re: Visualise differences with selectable reference https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Visualise-differences-with-selectable-reference/m-p/3688870#M143326 <P>current file:<BR /><A href="https://drive.google.com/file/d/1xV0HxMPvUKvYnsuraEUzrz84J4QPtTI2/view?usp=sharing" target="_blank">https://drive.google.com/file/d/1xV0HxMPvUKvYnsuraEUzrz84J4QPtTI2/view?usp=sharing</A></P><P>&nbsp;</P><P><img /><BR />the question is how can I calculate the standard value minus the values for each test individually?</P><P>&nbsp;</P> Thu, 08 Feb 2024 16:25:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Visualise-differences-with-selectable-reference/m-p/3688870#M143326 phill321 2024-02-08T16:25:39Z Re: Visualise differences with selectable reference https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Visualise-differences-with-selectable-reference/m-p/3689454#M143354 <P>Trying to make sense of your data.&nbsp;&nbsp;</P> <P>&nbsp;</P> <P>- are you comparing the materials against the standards for each of the quantities?</P> <P>- what happened to the non-numeric values? ("crack"&nbsp; etc)</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> Thu, 08 Feb 2024 22:00:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Visualise-differences-with-selectable-reference/m-p/3689454#M143354 lbendlin 2024-02-08T22:00:02Z Re: Visualise differences with selectable reference https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Visualise-differences-with-selectable-reference/m-p/3690264#M143398 <P><SPAN>I have now tried to update the task definition and implement a template in the original request.<BR /><BR /><SPAN class=""><SPAN class="">Regarding your questions:</SPAN></SPAN><BR /><SPAN class=""><SPAN class="">- In this version I removed all non-numeric values in order to reduce complexity.</SPAN></SPAN><BR /><SPAN class=""><SPAN class="">- Unfortunately, the name “Standard” is actually a bit misleading -&gt;</SPAN></SPAN> <SPAN class=""><SPAN class="">As you can now read above, the difference to a&nbsp;the name Standard 1/2/... is the name of the blank value that is needed to determine the confidence range and, if necessary, to be able to represent the influence of a 1%/3% input amount of a material.</SPAN></SPAN></SPAN></P> Fri, 09 Feb 2024 08:31:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Visualise-differences-with-selectable-reference/m-p/3690264#M143398 phill123 2024-02-09T08:31:51Z