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.
Hi, When i do this to my measure it does add a 0 to the measure, however when i have my matrix it expands the rows so it repeats 0's for rows that it shouldn't show. I assume i need to relate it somehow?
@orangeatom What is your dax function? And have you a screenshot of the resulting matrix?
Seems something like if the row total = 0 then return blank() for the row values, instead of zeros.
I found the solution by approaching the problem in a different view. What worked for my is to correctly keep blanks at the lowest grain of my measure which I now realize was a similar yet different problem. My solution was to create a measure with a variable and a return that correctly keeps the 0's.
Heyy, this works! Thanks!
For me it needs some final tweaking. I'm using a measure with a start and end date and I dont want it to show zeros before the start and after the zero, because I have 3 measures that follow up each other. See screenshot.
Kinldy assist, im still getting a blank on mine
Here's the formula: