Forum Discussion
Stratifying into 1/3rds Formula
Community SupportHi Anonymous ,
I created a simple sample that you could try and check if it is what you want.
They are all measures.
Cumulated Revenue =
CALCULATE (
SUM ( 'Table'[Revenue] ),
FILTER ( ALL ( 'Table' ), 'Table'[Business] <= MAX ( 'Table'[Business] ) )
)
Cumulated Percentage =
DIVIDE (
[Cumulated Revenue],
CALCULATE ( SUM ( 'Table'[Revenue] ), ALL ( 'Table' ) )
)
ABC Class =
SWITCH (
TRUE (),
[Cumulated Percentage] <= 0.33,5,
[Cumulated Percentage] <= 0.66,10,
15
)
For more details, Please see the attchment. If I misunderstanding, you could reference the DAX patterns blog to have a try.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
- v-xuding-msft
Hi Anonymous ,
> DAX comparison operations do not support comparing values of type Number with values of type Text.
Based on the error message, it might be caused by the parentheses. You could use this to format it and check it. And can you please share your formula and the data type of columns? Then we can find the error out.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Ashish_Mathur
Super User
Hi,
In the Query Editor, change the format of the numeric column to Decimal numbers.
- v-xuding-msft
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.
