topic Re: Zero instead Blank in a filter context in DAX Commands and Tips

Zero instead Blank in a filter context

Paolo_lito — Thu, 10 Feb 2022 17:23:21 GMT

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

Re: Zero instead Blank in a filter context

serpiva64 — Thu, 10 Feb 2022 22:41:02 GMT

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 !

Re: Zero instead Blank in a filter context

Paolo_lito — Fri, 11 Feb 2022 08:44:45 GMT

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

Re: Zero instead Blank in a filter context

tamerj1 — Fri, 11 Feb 2022 20:13:22 GMT

Try

VAR Code = Your Code

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

Return

Result

Re: Zero instead Blank in a filter context

NanDeb — Sat, 03 Dec 2022 16:25:05 GMT

Try

COALESCE( [Measure] , 0)

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