Forum Discussion

trwatts's avatar
trwatts
Helper I
4 years ago
Solved

Has one value with a field parameter error

Hi everyone, 

 

I am looking to use the hasonevalue and switch true to dynamically present some trend information using a field parameter. 

The below is the error and dax I currently have. 
Any help would be great. 

Error:
Calculation error in measure 'Switch Measures[Test Switch Value BUD Financial]: Column [Parameter Trend] is part of composite key, but not all columns of the composite key are included in the expression or its dependant expression

Dax:

Test Switch Value BUD Financial =
IF(HASONEVALUE('Parameter Trend'[Parameter Trend]),
SWITCH(TRUE(),
VALUES('Parameter Trend'[Parameter Trend])="Revenue", [BUD Revenue],
VALUES('Parameter Trend'[Parameter Trend Fields])="Activity 40032 Revenue", [BUD Activity 40032 Revenue],
VALUES('Parameter Trend'[Parameter Trend])="Expenses", [BUD Expenses]*-1,
VALUES('Parameter Trend'[Parameter Trend])="Salaries", [Bud Salaries]*-1,
VALUES('Parameter Trend'[Parameter Trend])="Activity Exp as % of Activity Revenue", [BUD Expenses]*-1,
VALUES('Parameter Trend'[Parameter Trend])="Salaries %", [BUD Surplus],
BLANK()),BLANK())
error
  • amitchandak's avatar
    amitchandak
    4 years ago

    trwatts , there is challenge when we directly check the value. I have used this code to check the selected value

    What is selected = maxx(filter('Axis Slicer', 'Axis Slicer'[Axis Slicer Order]= SELECTEDVALUE('Axis Slicer'[Axis Slicer Order])),'Axis Slicer'[Axis Slicer])

     

    Check if that is blank means , nothing selected 

     

    or try hasonevalue on order column

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    trwatts , there is challenge when we directly check the value. I have used this code to check the selected value

    What is selected = maxx(filter('Axis Slicer', 'Axis Slicer'[Axis Slicer Order]= SELECTEDVALUE('Axis Slicer'[Axis Slicer Order])),'Axis Slicer'[Axis Slicer])

     

    Check if that is blank means , nothing selected 

     

    or try hasonevalue on order column

    • trwatts's avatar
      trwatts
      Helper I
      4 years ago

      Thanks amitchandak 
      I have tried the order value in the hasonevalue section and havent had any luck. 
      Not sure exactly where to drop the formula you gave into the dax?

    • trwatts's avatar
      trwatts
      Helper I
      4 years ago

      Worked it out. 
      Thank you for your help it is greatly appreciated. 🙂