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 Anonymous ,
Have you resolved the problem? If yes, please accept the helpful answer as a solution. And welcome to share your solution. If you still have questions, please share a few screenshots to make us understand clearly.