DAX alternate between ALLSELECTED and ALL

[sabd80]

Hi,

I have request from the business that needs an option to select ALLSELECTED or ALL, rather than creating 2 different measure can I have one measure and can select between either ALLSELECTED or ALL.

Avg Tonnes =

CALCULATE(

    DIVIDE([Jan FC], [Budget], 0

    ),ALLSELECTED()

)

Avg Tonnes =

CALCULATE(

    DIVIDE([Jan FC], [Budget], 0

    ),ALL(Colm1, colm2)

)

[FreemanZ]

hi @sabd80 ,

instead of alternating between functions, you can use field parameter to alternate between measures. check this:

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

[sabd80]

Thanks @FreemanZ, I am aware of the field parameter, my whole point for this post is to avoid creating another set of measures.

[v-rzhou-msft]

Hi @sabd80 ,

As far as I know, measure could return results dynamiclly based on filter context. However, we couldn't change the code in a measure dynamiclly.
Here I suggest you to follow sabd80’s solution, Field Parameter should be a good workaround.

Best Regards,
Rico Zhou

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