Forum Discussion
Stratifying into 1/3rds Formula
I have around 50 companies and their revenue amounts. I want to create a column or a measure (not sure which would be best) to stratify the revenue amounts into 1/3rds by largest to smallest in reven...
After I made the cumulated Revenue measure I got the following error message:
MdxScript(Model) (4,101) Calculation error in measure [Cumulated Revenue}: DAX comparison operations do not support comparing values of type Number with values of type Text.
Hi,
In the Query Editor, change the format of the numeric column to Decimal numbers.