cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How to segment columns

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.

4 REPLIES 4
amitchandak
Super User
Super User

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

Anonymous
Not applicable

-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.
 

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.

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...

Helpful resources

Announcements
Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.