Forum Discussion

Niunias's avatar
Niunias
Frequent Visitor
5 years ago
Solved

Count unique cells with the same values

Hello,   I am trying to figure out a way to count unique cells with  values. I merged 6 files and all of them have multiple sheets with the same layouts. It contains statuses of the tests, files ar...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Niunias 

    Please check the below picture and the sample pbix file's link down below.

    All measures are in the sample pbix file.

     

    https://www.dropbox.com/s/eoyy7prq9f3c3mv/niuniasv2.pbix?dl=0 

     

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, Niunias 

Please check the below picture and the sample pbix file's link down below.

All measures are in the sample pbix file.

 

https://www.dropbox.com/s/eoyy7prq9f3c3mv/niuniasv2.pbix?dl=0 

 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

Niunias's avatar
Niunias
Frequent Visitor
5 years ago

Thank you, thank you so much 🙂