Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Get Distinct Call ID's when same call ID is in different transfer Numbers

Hi Team ,   I have two columns in my data one is Call ID and other is Transfer No as below   Call ID Transfer No 75643 1 75643 2 75643 3 17890 1 17890 2 17890 3 178...
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi, Anonymous 

    You can create a second mesure based on the first measure , like this:

    Measure 2 = SUMX( VALUES('Table'[Transfer No]), [Measure])

    Then we can meet your need:

     

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

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