Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in BI by (11.1k points)

I am a report in Power Bi which shows blanks instead of zeros

Is there any way to convert blank into zeros without using any measures

er

1 Answer

0 votes
by (22.5k points)

Include If into the measure

Sum =
IF (
    SUM ( Planilha1[VALOR CONVERTIDO ] ) = BLANK ();
    0;
    SUM ( Planilha1[VALOR CONVERTIDO ] )
)

Want to learn more about Power Bi, Refer: Power Bi Training  

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94.7k users

Browse Categories

...