Forum Discussion

JohnR1's avatar
JohnR1
New Member
8 years ago
Solved

filter dax

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 ...
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    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

     

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

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