Reply
Frequent Visitor
Posts: 9
Registered: ‎04-03-2018

Re: show items with no data as 0 instead of blanks

Do you have a copy of you DAX formula, by chance?

 

It sounds like you could do a count against the day column and use that as your denominator.

Frequent Visitor
Posts: 3
Registered: ‎08-03-2018

Re: show items with no data as 0 instead of blanks

I've had multiple connections and for some reason adding a zero made my pivot disconnect with everything else and eventually messing everything up... my logic is that when I added a fixed value which was not part of the datamodel and that's why my pivot disconnected from everything.

 

The solution (same same but different).... adding  + [var] - [var]... and the var should have some value, eg be a base value.

Highlighted
Occasional Visitor
Posts: 1
Registered: ‎10-23-2018

Re: show items with no data as 0 instead of blanks

Smartest and best answer!!

Frequent Visitor
Posts: 2
Registered: ‎11-09-2018

Re: show items with no data as 0 instead of blanks

Very elegant and saved me a bunch of time!