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.
Anonymous, one way to achieve it is by adding "FILTER" to the "ALL" function. For example:
CALCULATE ( [Measure] ,
FILTER ( ALL ( Table ) , Table [Date] > DATE ( 2021 , 9 , 4 ) )
)
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.
OFMG THERE ARE NO WORDS TO EXPRESS HOW MUCH I APPRECIATE YOU. Midterms coming up with this expected to be due in 24 hours for work with the last couple nights I've been haiving little to no sleep -- thank you. If I can send you a 10 dollar target giftcard --
Haha - Anonymous do not be silly big fella! No need for a gift card or anything like that at all! I just wish I could have given you what you were looking for sooner lol!
Best of luck with it all mate! You've put together a massive amount of effort in the file. Best of luck with it all (and make sure to remove the sharing of the PBIX otherwise someone else down the track will try take it for their assignment haha).