POWER BI ALLSELECTED fails when Sort Column By

Melbert van Emmerik 1 Reputation point
2020-06-09T19:12:45.683+00:00

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?

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,858 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Leon Laude 85,646 Reputation points
    2020-06-09T19:13:47.387+00:00

    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

    0 comments
  2. Dave Patrick 426K Reputation points MVP
    2020-06-09T19:13:50.583+00:00

    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.

    0 comments