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

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
Anonymous
Not applicable

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
v-shex-msft
Community Support
Community Support

Hi @Anonymous,

 

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 as solution to help other members find it more quickly.
Anonymous
Not applicable

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 

Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition
Anonymous
Not applicable

No change 😞

 

MICROSOFT 2.JPG

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors