Forum Discussion
static variable / parameter to be used across measures
- Anonymous2 years ago
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 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 !!