Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

infinity filtering help

Hello,    I've calculated the average for dates not within the last 30 days.   However, I want to apply this average to each line item in the last 30 days on another visual as a static number.  ...
Need Help
Tips and Tricks
  • TheoC's avatar
    TheoC
    4 years ago

    Hi Anonymous 

     

    If you're satisfied that your original measure is correct (i.e. 10.84%), and all you are trying to do is remove the blanks, I'd recommend doing this:

     

    By doing the above, your output will be as follows:

     

     

    Although I did look at the PBIX, with my limited level of acumen, it's hard to determine all of the measures and their calculations versus what you are trying to achieve with each.

     

    Hope the above helps mate.

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

  • TheoC's avatar
    TheoC
    Community Champion
    4 years ago

    @Jordanokstate, one way to achieve it is by adding "FILTER" to the "ALL" function.  For example: 

    Measure with Date Filter =
         CALCULATE ( [Measure] ,
              FILTER ( ALL ( Table ) , Table [Date] > DATE ( 2021 , 9 , 4 ) )
                           ) 
     
    Hope this helps mate!

    Mate, modified the measure based on seeing your screenshot.  Did not think to ask about the 9/5/2021 lol.  The DATE value should be DATE ( 2021 , 9 , 4 ) to return anything greater than 4 September 2021.