How to segment columns

[Anonymous]

Hi/Hola

Lo que ocurre es que tengo una segmentacion para una medida que yo creé (la medida la voy a llamar X)  y despues convertí esta medida X en una nueva columna (la columna la voy a llamar Y).

¿Como puedo hacer para que la segmentacion de datos que ya habia creado afecte tambien los datos de la columna Y?

Perdon, es que soy nuevo en power BI.

[amitchandak]

I think you have either create X as a Column or Y as the measure. If you can share calculation, we can check

[Anonymous]

-I have this measure:

MTTR DIC = IFERROR((SUM(MTTR_MTBF[TP Dic]))/(SUM(MTTR_MTBF[NE Dic]));0)

-And this measure its related with a segmentation named "ZONA"

-And i create a new column like this:

MTTR_dici = [MTTR_DIC]

Now I want than every time I use the segmentation MTTR_dici changes like MTTR_DICI does.

How can i do that?

Sorry for the bad english.

[v-juanli-msft]

Hi @Anonymous 

Measures can change with the slicers/columns added to the visual,

But calculated columns are stored in the data model once created.

So calculated columns are static and it would not change as measure does.

You could find more details regarding on measure vs calculated columns below:

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

To provide a solution to your problems, could you share more information?

eg.

what's final result do you want?

do you use any slicers?

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example. If possible please share a sample pbix file after removing sensitive information.
Thanks.

My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...