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.
I tried the following: Predicted_30d_Buy_from3d = CALCULATE(([3day Conversion]/[3/30 Flow Rate Avg]+0),ALL(Buys),FILTER(ALL('Date'),'Date'[Date]<[Max_Date]-100))
to attempt to get rid of the dates that I dont want. However, they still appear within the visual.
Anonymous, I'd recommend either breaking up the measure into multiple measures or use variables, just to help with the clarity. For example, using measures:
1. Measure n1 = [3day Conversion] / [3/30 Flow Rate Avg] + 0
2. Measure n2 = CALCULATE ( {Measure n1] , 'Date'[Date] > Date ( 2021, 9 , 4 ) , ALL ( 'Date' ) )
Let me know how the above goes. Worst case scenario, you can always just click on your visual (i.e. table) and go to the Filters on This Visual. Once you're there, go to Inquiries field, click on Fitler Type = Advanced Filtering and "is not blank" then hit apply. That will remove the blank rows.
Also, just out of curiousty, the two columns in your table, are they correct?
Let me know how it goes 🙂