Forum Discussion

pfprado's avatar
pfprado
Frequent Visitor
9 years ago
Solved

Get values outside the range selected

I need calculate a measure by month from a fact table, but outside the filter range, ie, I can filter the fact table and display the results in some graphics but I need a chart with the sum of data v...
Need Help
  • AlexChen's avatar
    AlexChen
    9 years ago

    Hi,

     

    This is not issue of  "out of range" table. I meaned that in the formula

     

    Table = SUMMARIZE(Filter(Test, Test[date] > Date(2016, 7, 31)), Test[Year], Test[Month Name], "monthAmount", sum(Test[amount]))

     

    the value "Date(2016, 7, 31)"  has to be a fixed value instead of a dynamic value here. You have to calculate it manually and put it here.

    Your plan to make a slicer to filter records in a table dynamically is not supported currently.

     

    Best Regards

    Alex

  • pfprado's avatar
    pfprado
    9 years ago

    Hi Alex, thanks for your help. Finally, I could generate a new table and calculate some measures from there.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

Sounds like you need something along the lines of ALLEXCEPT where get rid of your "date" context filter but keep everything else.

  • pfprado's avatar
    pfprado
    Frequent Visitor
    9 years ago

    I tried, but not works. I dont know how to use ALLEXCEPT function correctly. Can you help me?