Execute DAX written as text in table

jcichansky18 · ‎01-21-2022

Hi all,

I'd like to ask hypothetical question.

Let's imagine, that you have measure created in PBI: 'myPBImeasure=COUNTROWS( TableName )'. And now scenario 2: Let's create a table, which will have two columns: 'MeasureName' & 'MeasureDAX'. 'MeasureName' will be text 'DAXforCount' ; 'MeasureDAX' will be text '=COUNTROWS( TableName )'. Is there some way how to execute content of 'MeasureDAX' in PBI?

This is really only theoretical question.

Thanks!

Anonymous · ‎01-25-2022

Hi @jcichansky18 ,

Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thanks in advance for your kind cooperation!

Hope it helps,

Community Support Team _ Caitlyn

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

mahoneypat · ‎01-21-2022

I don't believe that is currently possible (it is in the query editor with M code, but that is not what you asked). However, you likely can use a disconnected table or a calculation group to get the same effect.

Improving the user experience by using a disconnected table to switch measures – PowerBI in educatio...

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube