Forum Discussion

saranp780's avatar
saranp780
Icon for Helper III rankHelper III
8 years ago

How to show the same data only one row (Use DAX)?

I know I can use remove duplicate before getting data into Power BI. But I want to use a formula because as long as I want to use this Power BI file again to show new result I just press refresh it.

 

Now I have some data below.

 

usernamenamesurname
PBI001SamSmith
PBI002MichelJohnson
PBI003SandreaThe R.
PBI004AndreaEmmanuel
PBI001SamSmith

 

I want to show 'PBI001' only one row because it is a duplicate one. So can anyone helps me?

Need Help

3 Replies

  • mmace1's avatar
    mmace1
    Icon for Impactful Individual rankImpactful Individual
    8 years ago

    The Matrix Visualization automatically does this, doesn't it? 

     

     

     

    • saranp780's avatar
      saranp780
      Icon for Helper III rankHelper III
      8 years ago

      I'm sorry for my wrong requirement. I have some different data after column 'surname'. So how can I do? if I don't want to remove duplicate.

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi saranp780,

     

    How about create a summarized table grouped by [username], [name] and [surname]?

     

    Regards,

    Yuliana Gu