Forum Discussion
mohammed_esam
7 years agoNew Member
Count numerical data type
Hello
I do have a dataset looks like
OrderID Order Status Order Step
1 approved 1
2 approved 2
3 cancelled 2
4 cancelled 3
5 cancelled 3
6 cancelled 3
7 cancelled 3
And I need to count the "Order Step" column which contain numeric data type.
For example the out should be:
Order Step Occurance
1 1
2 2
3 3
you can try this
Occurence = CALCULATE(COUNTROWS(orderstep), ALLEXCEPT(orderstep, orderstep[Order Step]))
1 Reply
- vanessafvgCommunity Champion
you can try this
Occurence = CALCULATE(COUNTROWS(orderstep), ALLEXCEPT(orderstep, orderstep[Order Step]))