Help with DAX ALLSelected

Hi Vamshi_PBI

Your problem may be related to using the ALLSELECTED function in DirectQuery mode.

One possible solution is to use the KEEPFILTERS function instead of ALLSELECTED. The KEEPFILTERS function preserves the existing filters in the filter context and applies them to the specified column or table. For example, you can create a new measure like this:

All Amount = 
    CALCULATE(
        SUM(FactSales[Amount]),
        KEEPFILTERS(FactSales)
    )

If you still have problems, it's best to provide the pbix file with your expected results and be careful to remove sensitive data.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.