Segmentation

[Anonymous]

Hello everyone,

Someone could help me?

I have a measure that calculates my churn rate:

Churn_Tx de Queda = DIVIDE([Churn_Caiu],[Churn_Solicitado])

And I would like to calculate this rate within an array that has the Fee and Lifetime segment.

I'm trying the following measure, but it's not working:

Churn por Segmento =

VAR vLimInfFee = MIN('SegmentaçãoFee'[Inf])

VAR vLimSupFee = MAX('SegmentaçãoFee'[Sup])

VAR vLimInfLT = MIN('SegmentaçãoLifetime'[Inf])

VAR vLimSupLT = MAX('SegmentaçãoLifetime'[Sup])

RETURN

CALCULATE( [Churn_Tx de Queda],

FILTER(

VALUES('fRelatório_Churn'[Card_id]),

VAR vFee = [Faturamento]

VAR vLT = [Total Lifetime]

RETURN

vFee >= vLimInfLT && vFee < vLimSupLT &&

vLT >= vLimInfFee && vLT < vLimSupFee

)

)

I would like to get a result like the one in the figure

How can I do it?

thank you

Karina

[amitchandak · Accepted solution]

@Anonymous , refer if my video and blog can help

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k