Forum Discussion
static variable / parameter to be used across measures
Hi ashwinkolte ,
amitchandak Thanks for your reply!
ashwinkolte If I understand you correctly, you mean to somehow reference this entire DAX without having to rewrite this code all over again in another DAX?I'm sorry this can't be done in DAX because this DAX is not complete, you can only store a complete DAX in Desktop (i.e. one that can output results properly) and not just a few lines of code.
If it is too much trouble for you to list all the conditions that need to be met by the Fieldintable each time, you can try the following:
Use this DAX to create a calculated table:Slicer = VALUES('Table'[Fieldintable])Use this table to create a slicer:
Then you can change your DAX like this (for example)
Measure = CALCULATE( SUM('Table'[Value]), 'Table'[Fieldintable] IN VALUES(Slicer[Fieldintable]) )What you need to calculate in Fieldintable, you just need to select it in slicer, no need to list them one by one in DAX.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI amitchandak Thanks for responding but that was not my question .I want to use that whole expression whther you use "=" or "IN" in other measures . So how can I have it in a parameter or a globally avaliable variable which I can just input as a filter value of Calculate function in other measures , rather than specifying all those values again in another measure . Hope the question is clear
Hi ashwinkolte ,
amitchandak Thanks for your reply!
ashwinkolte If I understand you correctly, you mean to somehow reference this entire DAX without having to rewrite this code all over again in another DAX?
I'm sorry this can't be done in DAX because this DAX is not complete, you can only store a complete DAX in Desktop (i.e. one that can output results properly) and not just a few lines of code.
If it is too much trouble for you to list all the conditions that need to be met by the Fieldintable each time, you can try the following:
Use this DAX to create a calculated table:
Slicer = VALUES('Table'[Fieldintable])
Use this table to create a slicer:
Then you can change your DAX like this (for example)
Measure =
CALCULATE(
SUM('Table'[Value]),
'Table'[Fieldintable] IN VALUES(Slicer[Fieldintable])
)What you need to calculate in Fieldintable, you just need to select it in slicer, no need to list them one by one in DAX.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
WOW . Thankyo so much !!