Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    I have checked the PBI, could you please show me which column in table is wrong?

     

    Aiolos Zhao

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous 

    Can you clarify what is the issue? I cant see any thing just from the model.

     

    Best,
    Paul

      • Anonymous's avatar
        Anonymous
        Not 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