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 .
Can you please help me ?
Thanks a lot
Go to Solution.
VAR Code = Your Code
VAR Result = IF ( ISBLANK ( Code ), 0, Code )
View solution in original post
COALESCE( [Measure] , 0)
@serpiva64 I tried but the result is the same . another Idea ?
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 !
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.