Empty change to 0 in matrix

[Erburi92]

Hello,

I have some issues with data. In matrix I want to change blank with 0, however it failed. I tried many functions, but them do not work:

Total Number of outcomes with no blanks =

IF (

    CALCULATE (

        counta(Sheet[Index])

            = 0

    ),

    0,

    counta(Sheet[Index]

))

and 

Zero instead of blank =

var Value_Total = CALCULATE( COUNTA(Sheet[Index] ) )

return

IF( ISBLANK( Value_Total )

    , 0

    , Value_Total

)

When I change column to date, formula works:

Can someone help me? I add some example.

https://www.dropbox.com/s/ebs1vr0flhd7vjq/example.pbix?dl=0

Thank you:)

[Syndicate_Admin]

There @Erburi92 ,

It seems the shared file has been deleted... Could you please share it again?

And if your problem has been resolved, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

[Anonymous · Accepted solution]

Hi,
Here is my workaround:
1. Create a separate table with distinct outcomes
2. Connect the tables on outcomes

3.Now use the "outcome" column from the new table for the visual
4. Change the dax for the measure as seen below.

Change dax to this:
Zero instead of blank =

Count(Sheet[Outcome]) + 0

[Erburi92]

I tried counta(Sheet[Index])+0, it does not work.

I do not need the matrix where the date is, I just show that with added dates formulas (I tried several different formulas) works, however, I need a matrix where the column is Reason and the row - Outcome (no date). With those columns (Reason and Outcome), no formula works when I need to change empty cells with 0.

[amitchandak]

@Erburi92 , Try like

counta(Sheet[Index])+0

it works better when you reason and month coming from another dimension