Forum Discussion

Kurtle's avatar
Kurtle
Helper II
6 years ago

Filter X-axis without filtering Data

Hi Friends, 

 

I am currently working with an accounting model that contains 2 date tables. One for the accounting date and one for the activity date. I am trying to filter the data down based on the accounting date but displaying it on activity date. 

 

The green box is my activity date and the red is accounting. So far so good. 

 

Now when I filter my chart to be from Jan 1, 2020 onwards I am losing some costs. The measure I am using is simple Field Expenses = Calculate( Sum( 'Line Items'[Amount]), 'Line Items'[Major Account] = "999") 

 

Does anyone have any suggestions on some Dax conditions that I can use to avoid this from happening? 

 

Here is the data model:

 

Thank you in advance! 

 

Need Help

3 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    6 years ago

    HI  Kurtle 

    What is "when I filter my chart to be from Jan 1, 2020 onwards I am losing some costs." ? 

    maybe you could adjust the measure as below:

    Field Expenses =
CALCULATE (
    SUM ( 'Line Items'[Amount] ),
    FILTER ( 'Line Items', 'Line Items'[Major Account] = "999" )
)

     

    If not your case, please share your sample pbix file and your expected output.

     

    Regards,

    Lin

    • Kurtle's avatar
      Kurtle
      Helper II
      6 years ago

      v-lili6-msft Oops. I should have clarified that. When I filter my activity dates down to be from Jan 1, 2020, onwards so that my bar chart only shows those bars  I lose some costs because there are 2 date columns in me Line Items Table which is getting filtered out during that process.