Forum Discussion
Matrix Visualization
Hi devesh_gupta ,
Thanks for your reply. I tried this solution but I cannot use CountID in a new measure as CountID itself is a self created Measure.
asad-mustafa-dc Can we try like this if it works for you:
CountIDOrZero = IF(ISBLANK([CountID]), 0, [CountID])devesh_gupta No it's giving same results as before. It's not showing 0 as values where no CountID exists.
asad-mustafa-dc Let's try these simpe steps:
Select the matrix visual.
On the Fields pane, locate the "Dept" field under the Rows section.
Click on the dropdown arrow next to the "Dept" field to open its context menu.
Check the option that says "Show items with no data." This option will ensure that all departments, even those without any CountID values, are displayed in your matrix visual.
If you find this insightful, please provide a Kudo and accept this as a solution.
