Forum Discussion
SSAS Tabular exponential column data mismatch
Hi team, I am facing data mismatch in SSAS tabular model cube beacuse of exponential data in column. refer screenshot for sample data. DAX: Calculate(sum(Table[Amount])) when i compare data ...
I have a similar issue. The keys I use are defined as 18,0 and they are unique. They are the PK in the SQL Server DB I use, so I know they are unique. But when I bring the table into SSAS Tabular it is displayed in scientific notation. Even if I change the data type to whole number I am not allowed to set the value to unique because SSAS see the numbers as duplicates but they are not.
This needs to be fixed.