cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

MIGRATE MEASURE TO CALCULATED COLUMN

Hi,

 

I created a measure what gave me a solution I was looking for... Now Im using "Card Browser" visual objetc which only accept columns as values... so I made diferent columns to make it work but there is on measure I cant transform it to a column...this is the reaction I get when I paste my measure formula to a calculated column.

 

 

Some one could help me out????

 

The measure Im trying to migrate to a calculated column is this:

ELITE RANK = 
VAR X = RANKX(ALLSELECTED(Estructura);[XVEN AC]+[RP*]/200)
RETURN
IF([NumberToShow Measure]=0; X; IF(X <= [NumberToShow Measure]+1; X))

 

Consulta Microsoft.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver I
Resolver I

Re: MIGRATE MEASURE TO CALCULATED COLUMN

After several different tries I could make it work. I dont even know what caused the failure though...what I did was to remake the dashboard from a couple of steps before and now everything work good even with multiple filters on as you said it could brake the content ... Ive been waiting if I could see errors...but it keeps working good ....So strange behaviour.

 

 

 @Greg_Deckler @v-shex-msft 

View solution in original post

4 REPLIES 4
Highlighted
Super User IV
Super User IV

Re: MIGRATE MEASURE TO CALCULATED COLUMN

Right, in a column context ALLSELECTED means your current row. Change that to ALL instead.


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Resolver I
Resolver I

Re: MIGRATE MEASURE TO CALCULATED COLUMN

No change 😞

 

MICROSOFT 2.JPG

Highlighted
Community Support
Community Support

Re: MIGRATE MEASURE TO CALCULATED COLUMN

Hi @chromo4130,

 

AFAIK, current power bi not support to create dynamic calculated column/table based on filter or slicer.

 

Dynamic measures can calculated based on current row contents, so it can get different result on different summary level.  When you use measure formula in calculated column, its row content will be broken(same as 'all' function effect) and get the result on whole table total level.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Resolver I
Resolver I

Re: MIGRATE MEASURE TO CALCULATED COLUMN

After several different tries I could make it work. I dont even know what caused the failure though...what I did was to remake the dashboard from a couple of steps before and now everything work good even with multiple filters on as you said it could brake the content ... Ive been waiting if I could see errors...but it keeps working good ....So strange behaviour.

 

 

 @Greg_Deckler @v-shex-msft 

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors