https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Display-result-without-sum-count-or-anything-else/m-p/2945955#M97465 <P>I created a new column and used the lookupvalue function to find the desired result.&nbsp; When I look at the data it is populating the column correctly for each row but when I try and place the value in my Matrix Vis, it automatically wants to sum or count the whole of the column.&nbsp; I just want to retrieve and display the individual result.&nbsp;</P><P>Is this a formatting issue or do I have to create another measure off of the new column measure?</P> Sat, 03 Dec 2022 15:00:38 GMT Dean_Mcghee 2022-12-03T15:00:38Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Display-result-without-sum-count-or-anything-else/m-p/2945955#M97465 <P>I created a new column and used the lookupvalue function to find the desired result.&nbsp; When I look at the data it is populating the column correctly for each row but when I try and place the value in my Matrix Vis, it automatically wants to sum or count the whole of the column.&nbsp; I just want to retrieve and display the individual result.&nbsp;</P><P>Is this a formatting issue or do I have to create another measure off of the new column measure?</P> Sat, 03 Dec 2022 15:00:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Display-result-without-sum-count-or-anything-else/m-p/2945955#M97465 Dean_Mcghee 2022-12-03T15:00:38Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Display-result-without-sum-count-or-anything-else/m-p/2945961#M97466 <P>In the table view highlight the new calculated column and then check the Don't Summarize box in the Ribbon</P> Sat, 03 Dec 2022 15:14:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Display-result-without-sum-count-or-anything-else/m-p/2945961#M97466 NanDeb 2022-12-03T15:14:40Z