Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

IF AND with Measures

Okay, I am Finally on the tail end of this ridiculously simple yet difficult bi. I feel like with every step I have run into some kind of wall, this is no exception. 

 

I have 2 measures, both a percent of total rank so if rank 6 of revenue out of 42 agents, they have a percent rank of 14.29. I have this for both revenue and productivity scores. 

 

                             

 

I wanted to do a simple IF AND statement to say,

 

This is returning blank, there should be a couple of people that fit the criteria between the two that should match. What am I doing wrong here or is there a workaround? 

Need Help
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    6 years ago

    Hi Anonymous ,

     

    You can change a single relationship to a both relationship. By the way, you need to change the direction of only one path at a time.

    The result like this,

     

     

     

    You can test which one is correct.

     

    If you have any questions, please kindly ask here and we will try to resolve it.        

     

    Best regards,

     

    Community Support Team _ zhenbw

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

4 Replies

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    Sorry for that we create a sample and do some tests, the IF function works fine. Maybe you can test whether these two conditions have results separately.

     

    Measure = IF([rank_percentage]>.75,"CAP","")

     

     

    Measure = IF([Productivity Score 2]>=1,"CAP","")

     

     

    Could you please show us the specific of measures? Such as [Dials Ranking Percentage] and [Talk Time Ranking Percentage].

     

    Could you please provide a mockup sample  based on the PBIX that we have shared or describe the fields of each tables and the relations between tables simply?

     

    It will be helpful if you can show us the exact expected result based on the tables.

     

    Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.     

     

    BTW, pbix as attached.

     

    Best regards,

     

    Community Support Team _ zhenbw

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

  • vivran22's avatar
    vivran22
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hello Anonymous 

     

    I have tried creating a mock file for the scenario, and the IF with AND statement seems to be working fine. 

     

     

    Can you share the pbix file with sample data? That would help in understanding the problem.

     

    Cheers!
    Vivek

    https://www.vivran.in/
    Connect on LinkedIn

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      The issue is within the relationship. they are not directly connected. So like this...

       

      They are both using the created by table (Roster) as a bridge using the same reference that is a date&name.

      I am trying to say if and between the two outside tables, is that possible?

      • v-zhenbw-msft's avatar
        v-zhenbw-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ,

         

        You can change a single relationship to a both relationship. By the way, you need to change the direction of only one path at a time.

        The result like this,

         

         

         

        You can test which one is correct.

         

        If you have any questions, please kindly ask here and we will try to resolve it.        

         

        Best regards,

         

        Community Support Team _ zhenbw

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