Populate Matrix Blank Fields with Values

[Anonymous]

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

[Ashish_Mathur]

Hi,

Does this measure work?

Measure = coalesce([your measure],0)

[Anonymous]

Hi @Ritaf1983 .  I tried that already and it didn't work.  I still get blank fields.  Any other thoughts?

[Ritaf1983 · Accepted solution]

Hi @Anonymous 
You can also try :
if (isblank(measure), 0, measure))

or
refer to the linked video:
https://www.youtube.com/watch?v=_cT9PB72fu8

or 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

[Ritaf1983]

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