Forum Discussion

ashwinkolte's avatar
ashwinkolte
Helper III
2 years ago
Solved

static variable / parameter to be used across measures

Hi 

 

I am using calculate function extensively for creating many measures . However for many measures the filter condition of the Calculate  is common (example shown below) .  Is there any way to create a filter variable or parameter or something to store this filter which I can refer/use in calculate functions of different measures as filter condition 

 

 

Table[Fieldintable] = "abc" ||
Table[Fieldintable] = "def" ||
Table[Fieldintable] = "ghi" ||
Table[Fieldintable] = "ljk"

Need Help
  • Anonymous's avatar
    Anonymous
    2 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.

4 Replies

    • ashwinkolte's avatar
      ashwinkolte
      Helper III
      2 years ago

      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 

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 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.