Forum Discussion
infinity filtering help
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.
Hi 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 🙂
This works to get the values into the table as shown below, but I still do not want the table to show any rows,prior to 9/5/2021. It currently shows it even though there is a filter on the visual becaose of the ALL on the measure. How would I get rid of those dates again?
Anonymous, 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.Maybe I'm doing something wrong. Here is the screenshot, it now returns 0% which isn't what I am looking for. Below you can find the the power bi file, specifically I am looking at the predicted_30d_buy_from 3d measure.
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.