not able to fill the blank spaces in my matrix visual

[Nithinbob24]

my table columns are capamt, monthname, paymentmonth ,

i created a matrix visual of the uploaded image i.e in Rows field - monthname ,columns field - paymentmonth and for values i gave an dax expression
capamtmes = IF(ISBLANK(SUM(Query3[capamt])),0.0,SUM(Query3[capamt])) as the value but the blank spaces are not replced with 0.0 ,
i tried COALESCE(SUM(Query3[capamt]),0.0) but this is also fill the blank spaces ,any suggestions please let me know

[Ritaf1983 · Accepted solution]

Hi @Nithinbob24 
you can use a measure like :

test = sum('Main table'[capamt])+0

The pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Kedar_Pande]

@Nithinbob24 

Adjusted measure:

capamtmes = 
IF(
HASONEVALUE(Query3[monthname]) && HASONEVALUE(Query3[paymentmonth]),
COALESCE(SUM(Query3[capamt]), 0.0),
0.0
)

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[Ritaf1983]

Hi @Nithinbob24 

Please provide workable sample data . It is hard to figure out what you want to achieve from the description alone.  

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

[Nithinbob24]

no i cant provide

[Ritaf1983 · Accepted solution]

Hi @Nithinbob24 
you can use a measure like :

test = sum('Main table'[capamt])+0

The pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Nithinbob24]

i tried this , but it did not work , thank you though for the reply

[Ritaf1983 · Accepted solution]

Did you download the PBIX?
And used the same model with 2 months's tables?

[Nithinbob24]

earlier i only used the measure, i did not see the model , it is working
Thank you so much for the help