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...
Need Help
  • 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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  v-yueyunzh-msft ,

The total is not coming correctly, Total should also come correctly.

Thanks

 

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Icon for Community Support rankCommunity Support
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