Distinct Value

[Anonymous]

@amitchandak May be you can help here as well.

I've created a measure like below:

Feature = CALCULATE(DISTINCTCOUNT('devops-query-spr2'[Work Item Type]),FILTER('devops-query-spr2','devops-query-spr2'[Work Item Type]= "Feature"))

but its giving be value as just "1" whereas the distinct value for Feature in the report is 89.

[amitchandak]

@Anonymous , You giving a filter on work item type and taking a distinct of that , They are from different tables, Hope this not key they are joined on

Feature = CALCULATE(DISTINCTCOUNT('devops-query-spr2'[Work Item Type]),FILTER('devops-query-spr2','devops-query-spr2'[Work Item Type]= "Feature"))

Are you using right column for distinct ?

or

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

@amitchandak Please see below table:

Work Item Type	Work Iteam iD	Title
Issue	1	abc
Bug	2	def
Feature	3	ghi
Feature	4	123
User Story	5	789

I want only count of distinct value of Feature from column "Work Item Type" which is 2 but its coming just 1 for me when I'm creating the measure.

Feature = CALCULATE(DISTINCTCOUNT('devops-query-spr2'[Work Item Type]),FILTER('devops-query-spr2','devops-query-spr2'[Work Item Type]= "Feature"))

[Anonymous]

@amitchandak if i use just count the value is coming correct but I want the distinct value which is 89.

[Anonymous · Accepted solution]

Feature = CALCULATE(DISTINCTCOUNT('devops-query-spr2'[Work Item Id]),FILTER('devops-query-spr2','devops-query-spr2'[Work Item Type] = "Feature"))

This resolved my issue. The count has supposed to be taken from a different column.

Regards,

Himanshu