topic Re: Problem using FILTER with ALLSELECTED in DAX Commands and Tips

Problem using FILTER with ALLSELECTED

Anonymous — Mon, 05 Dec 2022 22:37:14 GMT

Hello everyone!

I need some help here...
Currently I have a measure that calculates the percentage from grand total (this works perfectly).

I use the same measure (above) in another measure where I do a virtual relationship with a auxiliar table, to use dynamic categories.

The problem is that when I apply a FILTER formula, the result is always 100%.

Maybe its easy to solve but I can't find a solution.

Re: Problem using FILTER with ALLSELECTED

Anonymous — Tue, 06 Dec 2022 01:51:37 GMT

Hi Anonymous

Maybe you can add ALL() in your measure .The current line is returned without ALL(), and the context is returned with ALL().

ALL function (DAX) - DAX | Microsoft Learn

ALLSELECTED function (DAX) - DAX | Microsoft Learn

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Problem using FILTER with ALLSELECTED

Anonymous — Tue, 06 Dec 2022 11:46:09 GMT

Anonymous I've tried this way but it doesn't work.

I created a pbix that I am attaching here.

PBIX FILE EXAMPLE