Forum Discussion

RenanPNog's avatar
RenanPNog
Icon for Helper I rankHelper I
2 years ago

Problem on trying to show 0 when BLANK

Hello everyone! So, i'm having a tough time on trying to display 0 when my measure results in BLANK. I'm also attatching the powerBI file here so you guys can fully comprehend what i'm seeking......
Need Help
Tips and Tricks
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Please explain why you want to do that in the first place.  It is considered bad practice.

RenanPNog's avatar
RenanPNog
Icon for Helper I rankHelper I
2 years ago

lbendlin

The reason why i want to do that is because in my final report visualization i have many product_id's and campaigns, and i'm going to need to filter both of them in different ways, each product_id and campaign_id has different and multiple course_id's, and i would not like to filter my courses manually, since there are lots of'em.

 

I tried to explain this here "But guys, this turnarond is giving me goosebumps since in the future i'm getting multiples differente course_ids". I'm sorry if it was not clear enough, didn't mean to make it hard for you guys.

 

Thank you