Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
@amitchandak May be you can help here as well.
I've created a measure like below:
Solved! Go to Solution.
@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.
@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.
@amitchandak if i use just count the value is coming correct but I want the distinct value which is 89.