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:

I think it is coming from my Calculate funtion in the DAX to create to the Q122_PF measure. Is there a way to rewrite this and still get the same result?

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.

     

3 Replies

  • Syk's avatar
    Syk
    Resident Rockstar
    2 years ago

    Your error is saying that your measure 'Variance Dropdown 1' has the error...

    Either way, try this 

    Q122_PF =
CALCULATE (
    SUM ( 'GL Data'[P_FCST_AMOUNT_W] ),
    FILTER ( 'GL Data', 'GL Data'[VCH_QUARTER] = "Q1" && 'GL Data'[N_YEAR] = 2022 )
)
    • Chanise89's avatar
      Chanise89
      Helper I
      2 years ago

      Syk Variance Dropdown 1 is a table.


      I am trying to wirte a measure that will allow me to use Measure names in a slicer (Similar to how Field parameters work but for my use case - field parameters is not the best option) 

      So ultimately I am trying to create this measure:

       

      The data types for all of these columns are Text, but I believe the actual error is leading back to the mesaure used to create Q122_Actuals 

  • 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.