Convert measure into a For loop with IF Condition

[DYY94]

Hello Community, 

I want to to loop in this condition because it always gaves me '1' as a result.  

MR2 = 
Var mr365 = [MR/365] 
RETURN  
 IF ( mr365<1,1,mr365)

This is [MR/365] it's Measure: 

[v-stephen-msft]

Hi @DYY94 ,

Since I don't know how your [MR/365] metric was created, in the sample file on my side, it seems to be fine.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DYY94]

Hi @v-stephen-msft , 

Thanks for your reply ! 

Yes the code works fine like that but when i used it in other table it gave me always '1' for all columns.

I have shared a simplified file to understand more the issue. 

https://drive.google.com/file/d/1ZgsfLABoWKLXWfuh-A3SslgmZmAd0c40/view?usp=sharing

Thanks.

[amitchandak]

@DYY94 , Try if this can help

MR2 =
Var mr365 = [MR/365]
RETURN
Sumx(Values(Table[Maturire]) , IF ( mr365<1,1,mr365))

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[DYY94]

Hi @amitchandak , 

Thanks for your help. 

the code works fine but when i used in other table it always gave me '1'. 

it should return the real number from [MR2]. 

 

Here a simplifed file to understand the issue. 

https://drive.google.com/file/d/1ZgsfLABoWKLXWfuh-A3SslgmZmAd0c40/view?usp=sharing

Thanks.