If result big a number writie 'Orther' else Write cloum value

[sinanalmac]

I created A new table  the name is  FuTable .
The  futable  has  two  colums

"FU"  contais product name   and  it is unique

"MesaureDif"  contais  SUM(FuForecast[sales])-SUM(FUforecast[forecast]) .  it feeds from  FuSales table and it has FU colum  also    

FUTable  

FU	MeasureDif
A	10
B	9
C	8
D	7
E	6
F	5
G	4
H	3
K	2
L	1

I added  A Measure and determinate   Top  4  materilal 

Top 4 =  RANKX( All(FUTable);FUTable[MeasureDIF])

When I add     A new mesause  it doesnt work  

for example 

Measure = If(FUTable[TOP10]>4;"Others";FUTable[FU]) 
it is  not accept  FU table[FU]

When  I add a new colum . This time Formule  is not write "others " for smaller value  from  4

I just  want write "others"  for the product top4  value  less then  4 

[Greg_Deckler]

When you refer to columns in a measure, you must use an aggregation:

Measure = If(MAX(FUTable[TOP10])>4;"Others";FUTable[FU]) 

Seems like you could do this with a group also.

[sinanalmac]

Hi Greg, Thank you  for your Reply,
But The main problem is POwer BI  doesn't suggest the other column. it Only  suggests the calculated column

I want Write  FU name on this colum.

[Anonymous]

Try with using a SUM function:

=If(SUM(FUtable[Top10])>10;"Others",SUM(FUtable[FU]))

[sinanalmac]

Hi @Anonymous
Thank you  for  Repy  but it didn't work. 
 is there a function like 

If(SUM(FUtable[Top10])<10"Others",SHOWFIELDVALUE(FUtable[FU]))

I just want to   show   Futable valu  if  top10  Smaller  then 10  
I can  do that With  add column but   there is an  calculate filed  in  the FUTable

How CAn I Atach  my file  in this  message ?

Best regards

[Anonymous]

Can you use a dropbox and share a link to your file ?

[sinanalmac]

Hi again, here is my files link 

https://www.dropbox.com/sh/w4fuymtxiktwlpi/AACRx-JwF2QlVAocqj066qVZa?dl=0

 thank you for  your help 

[Anonymous]

Hi @sinanalmac,

If I understand correctly you want to write the name from FUTable[FU] for you top 10 based on [Sel__ABSDif] is that right?

So what's wrong with your current table? You have FU Name in the first column (left hand side) and your "Measure 2" seems to work?

If It is just a matter of removing "Others" you can use visual level filters and uncheck "others"

If instead of showing "other" you want to show the FU name change your measure to this:

Measure 2 = if(FUTable[TOP10]>10,MAX(FUTable[FU]),(SelectI[Sel_ABSDif]))

[sinanalmac]

 hi @Anonymous thank you for   reply  
 actually this  fucntion gives me excatly  what  I  want 

 Measure 2 = if(FUTable[TOP10]>10; "others"; MAX(FUTable[FU]))

But I realized something about the measure.   I can't use a measure in a pie chart as the legend value. I need to solve this issue by creating a column.

[v-juanli-msft]

Hi @sinanalmac

Tranform a measure to  a column

column = if(FUTable[TOP10]>10; "others"; FUTable[FU])

Best Regards

Maggie

[sinanalmac · Accepted solution]

Hi All,

I think  I solve  the  issue

Icreate FU  table  for  all calculated  table  "dis2,dis4 ,cum2,cum4"  then it worked .
Thank you all for  your   ideas and solutions

Best  regards 
Sinan