filter dax

[JohnR1]

Hi guys,

I have a issue with filter of a report, the report filter 10 last years in a measeure calculeted but the user final want see of the selection years those have not amount, for example years 2018 and 2016 (check image) the request user final show report years load with value 0. I dont know what to do for solved issue. help me please.... Regards

Thanks!!!!

[v-yuta-msft · Accepted solution]

Hi JohnR1,

I have reproduced your issue. In table DETALLE_CASOS, there's NULL value, right? I have made three sample tables(DETALLE_CASOS, HISTORICO, TIEMPO) like below based on your description:

 

I then create a measure using your DAX formula and use the measure to create a line chart, I reproduced your issue like below.

 

To solve this issue, you should replace NULL with 0, click Query Editor->Replace Values.

 

After applied&close, you can see value 0 in the line chart.

 

PBIX for your reference: https://www.dropbox.com/s/0dscajn1m1rwzkt/filter%20dax.pbix?dl=0 

Regards,

Jimmy Tao