Problem using FILTER with ALLSELECTED

[danielmorais]

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.

[danielmorais]

@v-yetao1-msft I've tried this way but it doesn't work.

I created a pbix that I am attaching here. 

PBIX FILE EXAMPLE 

[v-yetao1-msft]

Hi @danielmorais 

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.