Forum Discussion

B00m3r's avatar
B00m3r
Frequent Visitor
8 years ago
Solved

distinct values letters equal to 2 digit country code

I have a table similar to the below. I have 20,0000 assets from around the world prefixed with country code 2 digits follwed by other reference letters & numbers that indicate city, floor,room etc, e...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi B00m3r,

    For example, I create a sample table only including [Assert Name] column, then create a calculated column as Greg_Deckler posted.

    sample tablecreate a calculated column
    If you want to get how many asset name group by first 2 digit country code. Just select the calculated column and measure(count of assert name as row level), you will get expected result as follows.



    Best Regards,
    Angelia

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

Hi B00m3r,

Create a calculated column to get first two digits as Greg_Deckler posted, then count values based on the new calculated column. Please feel free to ask if you have other issue.

Best Regards,
Angelia

B00m3r's avatar
B00m3r
Frequent Visitor
8 years ago

Can you give me an example of the dax count values based on what you are suggesting here please?

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

    Hi B00m3r,

    For example, I create a sample table only including [Assert Name] column, then create a calculated column as Greg_Deckler posted.

    sample tablecreate a calculated column
    If you want to get how many asset name group by first 2 digit country code. Just select the calculated column and measure(count of assert name as row level), you will get expected result as follows.



    Best Regards,
    Angelia