Forum Discussion
How to replace empty cells to zero (0) in matrix column values using direct mode.
- Anonymous5 years ago
Hi Anonymous ,
I had a look at your file and have updated the file as you require.
Download the file here
Appreciate your kudo!! Mark this post as solution if this works for you.
Hi NikhilKumar,
Thank you for your response and time
Actually i have tried with given logic but its look like still am getting blank instead of 0.
here is my updated dax.
Measure Value = CALCULATE([Measure]+0,'Table'[Column] in DISTINCT('Column'[Column]))
statuscount=CALCULATE(count(table(productservice)+0,'Table'[product service] in DISTINCT('Table[[product service]))
here is how the data look like for some example
product status product service
open phase1
open phase1
open phase1
completed phase 2
completed phase 2
completed phase 2
completed phase 2
after adding data into matrix :
Product status open completed
product service
phase1 3
phase2 4
in above example i would like show 0 when there is no data associated with rows and columns
my expected output like below:
Product status open completed
product service
phase1 3 0
phase2 0 4
rows iam using as product service , columns using as Product status and values given as count(product service)
here to avoid blanks i have used adding +0 in count(product service),tried with comparing length of the count and also tried with new logic suggested by you. but still iam not able to show 0 intstead of blank .
please check and suggest your ideas. Thank you.
Thanks,
Mahi 1827
Hi Anonymous ,
If possible can you share pbix removing sensitive data or a sampke pbix?
Appreciate your kudos!!
- Anonymous5 years agoNot applicable
Hi Nikhil,
Thanks for your time, please check the sample file below. I have tried with both measure and measure 2 but still i am not able to show 0 instead of blank vallues.
https://1drv.ms/u/s!AlARJq6xd5KedVlP0zJpo2xgG_s?e=tR2Okt
Please share your ideas and solution. Thank you.
Thanks,
Mahi1827
- Anonymous5 years agoNot applicable
Hi Anonymous ,
I had a look at your file and have updated the file as you require.
Download the file here
Appreciate your kudo!! Mark this post as solution if this works for you.
- Anonymous5 years agoNot applicable
Hi Nikhil,
This logic is working as expected.Thank you so much for your time and help on this.
Thanks,
Mahi