Forum Discussion
jpereztang
Helper I
8 years agoChange measure value based on measure
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,
Hi,
Try this formula
=if([Is In Range]=0,MAXX(FILTER(ALL(Hoja1[Duration]),[Is In Range]=1),[Total]),[Total])
Hope this helps.
1 Reply
- Ashish_Mathur
Super User
Hi,
Try this formula
=if([Is In Range]=0,MAXX(FILTER(ALL(Hoja1[Duration]),[Is In Range]=1),[Total]),[Total])
Hope this helps.