https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/What-is-the-difference-between-Value-and-Selectedvalue/m-p/3862300#M150878 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;</P> <UL> <LI>VALUE attempts&nbsp;to converts a text to number. If success&nbsp;it returns the number if not it returns error</LI> <LI>VALUES returns the distinct list of column available in the current filter context. So it generally&nbsp;returns a single column table but if this table contains one distinct value it will automatically convert it to a scalar&nbsp;value.</LI> <LI>SELECTEDVALUE ( 'Table'[Column] ) = IF ( HASONEVALUE ( 'Table'[Column] ), VALUES ( 'Table'[Column] ) )</LI> </UL> Tue, 23 Apr 2024 12:27:39 GMT tamerj1 2024-04-23T12:27:39Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/What-is-the-difference-between-Value-and-Selectedvalue/m-p/3861874#M150864 Tue, 23 Apr 2024 10:08:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/What-is-the-difference-between-Value-and-Selectedvalue/m-p/3861874#M150864 Anonymous 2024-04-23T10:08:50Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/What-is-the-difference-between-Value-and-Selectedvalue/m-p/3862300#M150878 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;</P> <UL> <LI>VALUE attempts&nbsp;to converts a text to number. If success&nbsp;it returns the number if not it returns error</LI> <LI>VALUES returns the distinct list of column available in the current filter context. So it generally&nbsp;returns a single column table but if this table contains one distinct value it will automatically convert it to a scalar&nbsp;value.</LI> <LI>SELECTEDVALUE ( 'Table'[Column] ) = IF ( HASONEVALUE ( 'Table'[Column] ), VALUES ( 'Table'[Column] ) )</LI> </UL> Tue, 23 Apr 2024 12:27:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/What-is-the-difference-between-Value-and-Selectedvalue/m-p/3862300#M150878 tamerj1 2024-04-23T12:27:39Z