Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Use DAX expressions to set parameters?

Can you use DAX expressions to set parameters? Basically, I have a very large multi year detailed data set and a summary query. What I would like to do is use the summary query to present information...
Need Help
  • TomMartens's avatar
    TomMartens
    6 years ago

    Hey,

     

    PowerQuery queries are creating the "1st level" of the data model, the "2nd" level is created by something than can be considered as model processing, this "materializes" all the calculated column that have been added using DAX.

     

    Finally a user interacts with the model (2nd level) by selecting values from a slicer, etc ...

     

    These interactions can not be passed down to the levels that have been creating the data model. This explains why a measure can not be used inside a calculated column. From a technical point of view this is possibel, but the value of the calculated column will not change if the the measure will change, e.g. by a user interaction with the data model.

     

    Regards,

    Tom

giogua0483's avatar
giogua0483
Frequent Visitor
2 years ago

Hello everyone and thank you in advance for the help.
My question is related.
Sometimes,for decision of the management of a company they want to create different Reporting Database in a different SQL database for similar data, for this reason in Powerbi you need sometime to create different group of parameters where the name of the fields are perfectly the same.
Is possible with Dax to change the description inside the parameter so you don't need to create a group of parameters for each single different table in the SQL database, where the fields name are perfectly the same?