Show Blanks as Zero Values as opposed to empty cells

[Anonymous]

Hi Experts

I thought this was straight forward you just add +0 to the DAX as it add zero values to balnk cells.

Here is my DAX formula i want to zero data points not as blank but 0 as shown in the image they are current empty cells.

IMAGE

DAX

PMSComplaintsMN = CALCULATE(IF(ISBLANK(COUNTA('PMS_COMPLAINT'[MATERIAL_ID])),BLANK(),COUNTA('PMS_COMPLAINT'[MATERIAL_ID])),
    ALLSELECTED(PMS_FINANCIAL_PDS[ROLL12_COMPLETE_PDS_IND]))

[Anonymous · Accepted solution]

@Anonymous 

PMSComplaintsMN = CALCULATE(IF(ISBLANK(COUNTA('PMS_COMPLAINT'[MATERIAL_ID])),0,COUNTA('PMS_COMPLAINT'[MATERIAL_ID])),
    ALLSELECTED(PMS_FINANCIAL_PDS[ROLL12_COMPLETE_PDS_IND]))

Try this!

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Proud to be Datanaut!

[Anonymous]

Hi nsrshk1

add the 0 in the place or Blank(), throws my graph out. see images. 

Image below is correct 100% (with) blank in dax

Image 2 when blank is replaced with 0