Forum Discussion
Distinct count not returning a result
Hi Anonymous
I think Don't know in your table may not equal to the string in measure, so the measure couldn't find it.
You could try to copy Don't know from table and try again.
And here I will give you some advice.
If your table is like the following table I built, you can use 100% Stacked bar chart and count(distinct ) function in this visual.
My Table:
Or you can update your measure:
Measure = CALCULATE(DISTINCTCOUNT('Table'[Respid]),FILTER('Table','Table'[What sort of job?]=MAX('Table'[What sort of job?])))Result:
You can download the pbix file from this link: Distinct count not returning a result
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Not sure but can you give this a try.
Your visualization has Don't_Know ( has an underscore) while your measure does not have an underscore.
Let me know if this works, else please share sample data and expected output.
Regards,
Harsh Nathani
I was trying various formulas (and was going to keep the correct one once it worked!) hence the underscores etc
here's my updated screenshot...still no luck unfortunately
Hi Anonymous
I think Don't know in your table may not equal to the string in measure, so the measure couldn't find it.
You could try to copy Don't know from table and try again.
And here I will give you some advice.
If your table is like the following table I built, you can use 100% Stacked bar chart and count(distinct ) function in this visual.
My Table:
Or you can update your measure:
Measure = CALCULATE(DISTINCTCOUNT('Table'[Respid]),FILTER('Table','Table'[What sort of job?]=MAX('Table'[What sort of job?])))Result:
You can download the pbix file from this link: Distinct count not returning a result
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.