Forum Discussion
Total of Measure showing wrong value
I am having a calculated column with conditional IF statement. Using which I am trying to create the current and previous year total sales.. all the columns and measures have decimal value as datatyp...
Jayee
Responsive Resident
Responsive ResidentHi Anonymous ,
Try below measure
Measure = Sumx(summarize(tablename,[Date],"X",[Current Year]),[X])
If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!