Change measure value based on measure

[jpereztang]

Hi everyone,

I know you have an idea how to achieve it.

this is my data

As simple as it appears i want to put the max value of Total column when [Is in Range] column is 1 for all rows that [is in Range] column is zero.

These are my formulas

RankByDur = IF(ISBLANK([Total]), BLANK()
		,RANKX(ALLSELECTED(Hoja1[Duration]), [Total], ,0)
)

Is In Range = IF(ISBLANK([Total]), BLANK(),
               IF([RankByDur]>[Outlier Count] , 1, 0))

Total changing outlier = IF([Is In Range]=1
								,[Total] 
								, 1
)

Also if you want u can download pbix test from here:

https://www.dropbox.com/s/puq0nw8vrdg45zc/Replacing%20value%20test.pbix?dl=0

Thanks in advance,

[Ashish_Mathur · Accepted solution]

Hi,

Try this formula

=if([Is In Range]=0,MAXX(FILTER(ALL(Hoja1[Duration]),[Is In Range]=1),[Total]),[Total])

Hope this helps.