topic Re: Apply a DAX expression stored in a table in DAX Commands and Tips

Apply a DAX expression stored in a table

Fgcillian — Tue, 24 Jan 2023 11:45:07 GMT

I'm struggling with an requirement and I don't really know if it can be done in Power BI.

Requirements: 1)DAX expressions will be stored in a column within a table imported in the data model of PBI.
2) Dinamically a Mesaure within Power BI should take the DAX expresion stored and apply it.

I attach a small example of what I´m trying to do.

From Data table (Data):

Customer	Data
CLIENT1	145
CLIENT1	54
CLIENT1	777
CLIENT1	12
CLIENT1	55
CLIENT1	888
CLIENT1	12

I need to apply the DAX expression stored in the following table (Expression):

Customer	Expression
CLIENT 1	MAX(Data[Data])

For that, I'm creating a Measure that applies the expression using the CALCULATE function:

MAX_FROM_TABLE =

VAR _evalExpression = (ALL( 'EXPRESSIONS'[Expression] ))

RETURN

CALCULATE(_evalExpression)

The calculate returns the stored DAX but do not applies the formula:

Is this possible with DAX? Which expression should I use?

Any help would be appreciated thanks.
Greetings from Spain.

Re: Apply a DAX expression stored in a table

amitchandak — Wed, 25 Jan 2023 02:24:33 GMT

Fgcillian , Try like

calculate(MAX(Data[Data]), all())

Re: Apply a DAX expression stored in a table

v-yueyunzh-msft — Thu, 26 Jan 2023 02:26:06 GMT

Hi , Fgcillian

According to your description, you want to put a DAX expression in a table and then use a function to call the field.

According to my research, this is currently not possible in Power BI, and there is currently no function in the DAX function that can call text text to run expressions.

For your stored "MAX(Data[Data])", stored in Power BI is just a normal string format, so whatever formula is used, a string literal is returned.

With Measure, what is stored is really just a formula, which is only calculated when it needs to be calculated. For your different needs, you can try to create multiple measures or use some conditional judgment functions to meet your different needs.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!

Best Regards,

Aniya Zhang

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

Re: Apply a DAX expression stored in a table

Fgcillian — Wed, 01 Feb 2023 08:20:07 GMT

Thanks Aniya for your feedback.

It's clear now.

Best regards,

Cillian