Help needed for DAX query

[koningii]

I hope you can help me. I am new to powerbi and looking how I can use a dax query for this problem Ik want to to show the unique amount of sample code which is 6

Dataset

Sample Code.    Results

AA.                        1

BB.                         2

CC                         2

DD                         4

EE                         4

FF                         4

Total                  17

[Greg_Deckler]

OK, explain how you got to 5.

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[koningii]

@Greg_Deckler I made a mistake It should be 6 instead of 5. 

[v-xuding-msft · Accepted solution]

Hi @koningii ,

I'm not clear what you want. Do you want to count Sample Code? If so, you could try the function of DISTINCTCOUNT. 

Measure = DISTINCTCOUNT('Table'[Sample code])

 

If it can't help you, can you please share more details and your expected results?