Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
My calendar table has dates between 1-1-2000 and 31-12-2017.
However, the facts table, contains data only between 1-11-2016 and 1-3-2017.
In a measure, I used the the following expression to display a measure in a matrix:
Saldo em EUR = IF(ISBLANK(SUM('Table1'[Column1]));BLANK();CALCULATE( etc... ))
This measure checks if the sim of Column1 is blank and it shows a blank field in the matrix tough preventing it from showing all the dates range in the calendar table.
But - It also show a blank field for the dates within the facts table where there's no value for the sum of column1.
I'd like it to show a zero instead of a blank field - how can I do that and still preventing the matrix from showing all the dates range in the calendar table?
Thanks in advance for helping!
Solved! Go to Solution.
Try adding + 0 either to the whole expression or just to the false argument (the CALCULATE part)
Try adding + 0 either to the whole expression or just to the false argument (the CALCULATE part)