Morning folks. I have attached an example excel data sheet. I am wanting to examine the waiters who had at least 15 checks or at least 70 people in total for all of their checks. And then find the highest average total bill. Would this be a simple DAX in the formula tool?
Hi @Jackmcc26,
You can use formula in the filter tool so I would say a filter tool will fit your requirement.
As for the 'highest average total bill', you would need to provide more explanation on the formula.
Hope this helps.
Cheers,
Lelia