question

MelbertvanEmmerik-1891 avatar image
0 Votes"
MelbertvanEmmerik-1891 asked DSPatrick answered

POWER BI ALLSELECTED fails when Sort Column By

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-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LeonLaude avatar image
0 Votes"
LeonLaude answered

Hi,

Q&A currently supports the products listed over here https://docs.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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DSPatrick avatar image
0 Votes"
DSPatrick answered

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.





5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.