Forum Discussion
Populate Matrix Blank Fields with Values
Hello,
Is there a way to populate blank fields in a matrix with a value such as 0 if there is no data? In the matrix I am working on below, there are carriers that have no data for either 2022 or 2023 as you can see below and the fields are blank. If possible I would like those blank fields to be populated with a 0 if blank but I can't seem to figure it out and it seems to because there is no data for those years. Any help would be appreciated.
Thanks,
Tim
Hi Anonymous
You can add 0 to your measure ( measure = abc+0)If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Anonymous
You can also try :
if (isblank(measure), 0, measure))or
refer to the linked video:
https://www.youtube.com/watch?v=_cT9PB72fu8or share a link to dummy pbix without sensitive data to work with.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
4 Replies
Hi Anonymous
You can add 0 to your measure ( measure = abc+0)If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Ritaf1983 . I tried that already and it didn't work. I still get blank fields. Any other thoughts?
Hi Anonymous
You can also try :
if (isblank(measure), 0, measure))or
refer to the linked video:
https://www.youtube.com/watch?v=_cT9PB72fu8or share a link to dummy pbix without sensitive data to work with.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi,
Does this measure work?
Measure = coalesce([your measure],0)
