Matrics Table with Blank Rows

[Anonymous]

Hello,

I am facing weird issue when using Matrix Visualization to show Measure in the rows. it shows blank instead of 0.

Note: if i use simple table visualization the same rows shows 0 and not blank. Data set has rows with 0.

My source of data is SAP BW BEX query.

I searched up other post and tried to add 0 in the value which didnt help.

Also, tried: Column = IF ( ISBLANK(CALCULATE(SUM( ('YKP CATS Report for IM Team'[CATS HOURS])))), 0 ,CALCULATE(SUM('YKP CATS Report for IM Team'[CATS HOURS])))

Which didnt help either.

This blank is causing me issue for further % calculations.

I am using total of row into further calculation example:

 Measure = DIVIDE( SUM ('YKP CATS Report for IM Team'[Actual Working Days]), 'YKP CATS Report for IM Team'[Measure Calc])*100

Where,

Actual Working Days = Total of Rows from above table.

 Measure Calc = ('YKP CATS Report for IM Team'[Max of Month]*'YKP CATS Report for IM Team'[Target Working Days])

Max of month (Period) and Target Working date :

But coz the blank rows I get below:

I am assuming that if i can resolve and replace blank with 0 , i will be able to solve my % issue and infinity will be gone.

Can someone help ?

Regards,

K

[amitchandak · Accepted solution]

@Anonymous , You can add +0 but that can add additional values as it will create left join

example : Measure = DIVIDE( SUM ('YKP CATS Report for IM Team'[Actual Working Days]), 'YKP CATS Report for IM Team'[Measure Calc])*100 +0

This may be better

Measure = DIVIDE( SUM ('YKP CATS Report for IM Team'[Actual Working Days]), 'YKP CATS Report for IM Team'[Measure Calc] , 0)*100

Also Not need to multiply by 100 as you can mark it % column from Measure tool