Filtering value of Measure

[ZIMLbaeza]

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 

[parry2k]

@ZIMLbaeza not sure what you are trying to achieve but measure can be used in visual level filters.

[ZIMLbaeza]

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

[v-yuta-msft · Accepted solution]

@ZIMLbaeza ,

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.