Zero instead Blank in a filter context

[Paolo_lito]

Hi ,

Hope you can help me on this subject .

I would like to have zero instead Blank in my Matrix  but only for the filtered value

If I add a Zero as suggested the most of the time then  the filters used in my measure seems be  broken and all non filtered are there .  see hereunder my dax measure .

CALCULATE (

SUM('Transaction'[Amount]),

   FILTER('Group Order','Group Order'[group_name] ="Conservation programs"),

   FILTER('SubGroup Order','SubGroup Order'[Subgroup_name] ="Programs Income"),

   FILTER('SubSection Order', 'SubSection Order'[subsection_name] IN {"Amazone & Guyanas","Congo basin","Great Rift        Lakes","Mekong"}),

FILTER(Project,Project[Project sub code] IN {"dgd phase 1","dgd phase 2"}) ,

FILTER(Scenario,Scenario[scenario type] ="Actual" || Scenario[scenario type] ="BF" )

) + 0

Can you please help me ? 

Thanks a lot 

[NanDeb]

Try

COALESCE( [Measure] , 0)

https://learn.microsoft.com/en-us/dax/coalesce-function-dax

[tamerj1 · Accepted solution]

Try 

VAR Code = Your Code

VAR Result = IF ( ISBLANK ( Code ), 0, Code )

Return

Result

[Paolo_lito]

@serpiva64  I tried but the result is the same . another Idea ?

[serpiva64]

Hi,

i have seen your measure with the zero at the end.

instead you can try without the ending zero but creating a new measure = the name of the basic measure +0

If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !