Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All
I have a Projects table - example below:
Project_ID | Go_Live_Date |
1 | 01/01/2024 |
2 | 12/01/2024 |
3 | 11/03/2024 |
4 | 01/04/2024 |
I have a line graph visulation with:
This works fine and shows total projects per month except its not showing a zero value for Feb when there is no project with a Go_Live_Date. Do I need to create a seperate Count measure and use some clever DAX?
Thanks!
Solved! Go to Solution.
Hi,
Try this approach.
Measure = coalesce(distinctcount(AllProjects[ID]),0)
Hope this helps.
Hi,
Try this approach.
Measure = coalesce(distinctcount(AllProjects[ID]),0)
Hope this helps.
Hi Ashish
I do have 1 more query if thats ok? I would like to add a filter to the measure dependant on another column value. Something like this:
However, im getting the following error: The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
Is there a way to achieve this?
Thanks
Hi,
Does this measure work?
Measure = coalesce(calculate(distinctcount(AllProjects[id]),AllProjects[m_a] = "True"),0)
If TRUE is a boolean value, then remove the double quotes.
Hope this helps.
Thats worked perfectly. Thank you
You are welcome.
Thanks. With your instructions (and a bit of fiddling with the sort), the graph is visualizing as i want it.
Greatly appreciated!
You are welcome.
Hello @MyThumbsClick ,
Yes you have to create separate measure for the count and after creating measure at the end of the measure please mention '+0' so that if the value is blank it will show '0'
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
Thanks Kishore_KVN
I created the below basic measure which does the trick and shows a zero value for where there is no count.
projects_per_month_count = DISTINCTCOUNT(AllProjects[id])+0
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |