show items with no data

[vani]

Hello guys,

I´ve the following visualization:

Instead of having Mar/17 and then Mar/20 and want to see those days that i´ve no data ( this case on Mar/18 and Mar/19).

I tried the following formula:

Sales last 30 days  = if(CALCULATE(SUM(FACT_INSCRICOES[PRATICANTES]);FACT_INSCRICOES[IND_LAST_30_DAYS]=1)=blank();0;CALCULATE(SUM(FACT_INSCRICOES[PRATICANTES]);FACT_INSCRICOES[IND_LAST_30_DAYS]=1))

but when apply it , instead of show the last 30 days, it show me all dates that has no data instead of show just the last 30 days that i have marked on the calculated column.

Any sugestions? 

Thanks

[bblais · Accepted solution]

Try just this:

Sales Last 30 Days = SUM(FACT_INSCRICOES[PRATICANTES])+0

Then use a slicer or other filter to limit your visual to only showing the last 30 days.  The +0 will always give 0 if there are no sales for that day. 

[vani]

@bblais

Many thanks for the sugestion. I just use the filter IND_LAST_30_DAYS as visual level filters and the formula as you suggested and it works fine!

Thanks you