Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
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
0 votes
1 answer

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...