Forum Discussion
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. ...
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.
TheoC
Community Champion
Community ChampionHi Anonymous
I may not entirely understand what you are asking, so my apologies! However, what you may be looking for is something to ignore filters. If you have one table, then use measure one. If you are cross analysing two tables, use measure two.
- One Table Filter = CALCULATE ( [MEASURE] , ALL ( Table1 ) )
- Two Table Filter = CALCULATE ( [MEASURE] , ALL ( Table1 ) , ALL (Table2) )
Let me know if this helps 🙂