Forum Discussion
cmackie
1 year agoRegular Visitor
ALLEXCEPT Not Working With Filters On Visual
I am having issues with getting the ALLEXCEPT function to ignore filters on a visual... My model is as below: Essentially what I am trying to achieve is to discover the percentage of de...
Selva-Salimi
1 year agoSolution Sage
Hi cmackie ,
I think you should also add "status" in allexcept expression.
If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.
cmackie
1 year agoRegular Visitor
Hi Selva-Salimi
I do not think this is the case as you'll see from the screenshot that adding in "status" to the allexcept expression results in 201 (see Ignore proposal date):
As you can see, the "Ignore Proposal Date" essentially has "Status" and "Proposal Date" in the allexcept albeit a bit disjointed and messy.