Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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)
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.
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.
@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.
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.
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |