Forum Discussion

Chanise89's avatar
Chanise89
Helper I
2 years ago
Solved

Another option to write a CALCULATE function

I need some assistance with trying to rewrite a DAX without the use of CALCULATE:   I am trying to recreate a solution from another post, however I keep running into this error message: ...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Chanise89 ,

     

    Try to modify your measure like below:

    Variance select 1 =
SWITCH (
    TRUE (),
    VALUES ( 'var dropdown #2'[#1] ) = "Q122_Actuals", [Q122_Actuals 2],
    VALUES ( 'var dropdown #2'[#1] ) = "Q122_Plan", [Q122_PF 2],
    BLANK ()
)

     

    Best Regards,
    Adamk Kong

     

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

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Chanise89 ,

 

Try to modify your measure like below:

Variance select 1 =
SWITCH (
    TRUE (),
    VALUES ( 'var dropdown #2'[#1] ) = "Q122_Actuals", [Q122_Actuals 2],
    VALUES ( 'var dropdown #2'[#1] ) = "Q122_Plan", [Q122_PF 2],
    BLANK ()
)

 

Best Regards,
Adamk Kong

 

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