Forum Discussion
Filtering value of Measure
Good afternoon everyone,
I have a simple measure : T_Qty = SUM(tablex [qty])
I wanted to show the value of that measure filtering its own value. I mean:
SUM t_qty where t_qty is > 100
SUM t_qty where t_qty is 50 to 99
SUM t_qty where t_qty 25 to 49...
Maybe you can help me. Thanks in advance
Measure can not be summed, you need to convert t_qty to calculate columns.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
I wanted to group the value of my measure like I said.
Also, my measure is refered to a customer register.
Is there any chance to know how many customers have more than t_qty > 100?
In fact, what I want is that:
Count customers that have t_Qty > 100 --- t_qty(SUM) for this group of customers (t_qty > 100)
Count customers that have t_Qty > 50 to 99 --- t_qty(SUM) for this group of customers (t_qty > 50 to 99)
Maybe this helps you. Thanks
Measure can not be summed, you need to convert t_qty to calculate columns.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
