POWER BI ALLSELECTED fails when Sort Column By

Question

If have created the following measure:
Subtotal= CALCULATE(sum('Table'[Value]);ALLSELECTED('Table'[Month]))

The result is a subtotal of Value by Month.
Everything is fine.

But then I use 'Sort Column By' to change the sorting order of Month by the field Month_nr.
Then ALLSELECTED fails.

Also changing to Subtotal= CALCULATE(sum('Table'[Value]);ALLSELECTED('Table'[Month_nr])) is not working.

How can I solve this?

Answer

Hi,

Q&A currently supports the products listed over here https://learn.microsoft.com/en-us/answers/products (more to be added later on).

You can reach the experts in the dedicated Power BI forum over here:
https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums

(Please don't forget to accept helpful replies as answer)

Best regards,
Leon

Answer

Poer Bi is not currently supported here on QnA. They're actively answering question in dedicated forums here.

https://community.powerbi.com/

--please don't forget to Accept as answer if the reply is helpful--

Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management

Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

2 answers