Forum Discussion

RichardV's avatar
RichardV
Advocate IV
8 years ago
Solved

Dax: blank values +0 formula

Hi guys,   I was wondering if somebody could help me. It is concerning a PBI report with 2 visualisations, and I am working with an SSAS tabular model.   Visualisation 1: line graph with date (by...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi RichardV,

     

    You can use IF condition in your measure like:

    Measure = IF(MAX(Table[Date].[MonthNo])<=MONTH(TODAY()),[amount of files]+0,BLANK())

    Remember to enable 'Show items with no data' on chart axis.

     

    Best regards,
    Yuliana Gu

  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi RichardV,

     

    So, currently, with this formula Measure= IF(MAX('Table'[Date])>DAY(TODAY()) . [Amount of files]+0, BLANK()), you can always achieve the desired result, right?

     

    Regards,
    Yuliana  Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi RichardV,

 

So, currently, with this formula Measure= IF(MAX('Table'[Date])>DAY(TODAY()) . [Amount of files]+0, BLANK()), you can always achieve the desired result, right?

 

Regards,
Yuliana  Gu

RichardV's avatar
RichardV
Advocate IV
8 years ago

Yes, although no idea why it works