Forum Discussion
IF statement not populating proper result
hi All,
I have this PBI file which has few calcuated measures. I am trying to create a new company Column/measure as below:
If (Company Share < 2%, "Others", [Company])
Howwever, if function is yielding proper results. The calculations are working fine. Infact, I created another calculated measure (Include/Exclude) to check if everything works fine. It seems there is another issue.
Below is the sanitized version of the PBI file i am using:
https://www.dropbox.com/s/dvkse68bm8pndkm/for%20community.pbix?dl=0
Can someone guide me to the solution.
Regards,
Kaushik
10 Replies
- AnonymousNot applicable
Hi Anonymous ,
I have checked the PBI, could you please show me which column in table is wrong?
Aiolos Zhao
- AnonymousNot applicable
Anonymous
Can you clarify what is the issue? I cant see any thing just from the model.Best,
Paul- AnonymousNot applicable
Anonymous Anonymous
I the PBI file uploaded on the link, the New_company calculated column is not yielding the correct result.
https://www.dropbox.com/s/dvkse68bm8pndkm/for%20community.pbix?dl=0
Regards,
Kaushik
- AnonymousNot applicable
Hi Anonymous ,
Please try to change it to below measure:
Measure = IF([Company Share]>0.02, MAX('Growth Growth Chart Input File'[Company]),"Others")Aiolos Zhao